Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have a custome tile on a report that rotates. I have 2 datasets that feed into the tile.
Dataset 1 is a complete list of "closures" all I do here is drag a field into the Measures and do a count of that field.
Dataset 2 is a table of targets by date. I have created a relationship betweeb the 2 datasets on date. The measure used from here is sumoftarget. This works perfectly, however I want to be able to calculate percentage of countoffield1/sumoftargets, any ideas how I go about this?
Hi @carlm1975,
Please share a sample and the expected result? How about function DIVIDE?
Best Regards,
Dale
Hi @carlm1975,
Try it in this file.
The measure is:
Measure = DIVIDE(COUNT(Table1[Closed By]),sum(Table2[Target]))
Best Regards,
Dale
I have for example the following in dataset one
Date Closed By
01/01/18 Mr smith
01/01/18 Mr Jones
02/01/18 Miss Bunny
03/01/18 Mr Green
02/01/18 Mr Brown
In dataset 2 I have
Date Target
01/01/18 4
02/01/18 4
03/01/18 1
In the measure section of my tile I would have
Count of ClosedBy = 5
Sum of Target = 9
I want to be able to create a third that gives me 5/9 as percentage
There is also a chart on the report that shows count of closed by as a bar and target as a line by day. Therefore when one of the bars is chosen the rotating tile auto changes to show figures just for that day.
Cheers
I dont know how to add countofclosedby / sumoftarget as a new measure
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |