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
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
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?
Go to Solution.
To create a measure as below. If it doesn't meet your requirement, kindly share your excepted result to me.
DISTINCTCOUNT ( Table1[Shop] ),
FILTER ( Table1, 'Table1'[target met] = 1 )
/ CALCULATE ( DISTINCTCOUNT ( Table1[Shop] ), ALL ( Table1 ) )
View solution in original post
Thanks for reply and .pbix file
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
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!