Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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%.
How can we best achieve this in power bi?
Thanks
Solved! Go to Solution.
Hi @po,
Based on my test, you could refer to below measure:
Measure = CALCULATE(COUNT(Table1[target]),FILTER('Table1','Table1'[target]<>0))/COUNT(Table1[target])
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi @po,
Based on my test, you could refer to below measure:
Measure = CALCULATE(COUNT(Table1[target]),FILTER('Table1','Table1'[target]<>0))/COUNT(Table1[target])
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Thanks for reply and .pbix file