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,
Wish to calculate the following
Percentage of Shops which hit target which varies dynamically depending on w/edate and store name which selected in slicers
Data
Shop, W/E date, target met
target met is derived in table and can set correctly at table level to 0 depeidning on store percentage above 70, target met is set to 1
e.g
A, 05/01/2019,0
A,12/01/2019,0
A,19/01/2019,1
B, 05/01/2019,0
B,12/01/2019,1
B,19/01/2019,1
C, 05/01/2019,1
C,12/01/2019,1
C,19/01/2019,1
i.e. in above if looked at all this median OF A is 0, b is 1 and c is 1 i.e. 66% met target i.e 2 out of 3 stores met target.
However if were just looking at 19/01/2019 all met target i.e. would be 100%.
Tried
How can we best achieve this in power bi?
Thanks
Solved! Go to Solution.
Hi @po,
To create a measure as below. If it doesn't meet your requirement, kindly share your excepted result to me.
Measure = CALCULATE ( DISTINCTCOUNT ( Table1[Shop] ), FILTER ( Table1, 'Table1'[target met] = 1 ) ) / CALCULATE ( DISTINCTCOUNT ( Table1[Shop] ), ALL ( Table1 ) )
Regards,
Frank
Hi @po,
To create a measure as below. If it doesn't meet your requirement, kindly share your excepted result to me.
Measure = CALCULATE ( DISTINCTCOUNT ( Table1[Shop] ), FILTER ( Table1, 'Table1'[target met] = 1 ) ) / CALCULATE ( DISTINCTCOUNT ( Table1[Shop] ), ALL ( Table1 ) )
Regards,
Frank
Hi
Thanks for reply and .pbix file
Hi,
Just a quick question.
If wish to do an average for the shop and the count of the ones where average = 0 how could we do this?
Can calculate the average
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |