count of median

[po]

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 thsi data MEDIA OF A is 0, b is 1 and c is 1 i.e. 66% 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

[v-yuta-msft · Accepted solution]

@po,

To achieve your requirement, create a measure using DAX formula below:

Met Or Not = 
VAR Percentage = CALCULATE(SUM(Table1[target met]), ALLSELECTED(Table1)) / CALCULATE(COUNT(Table1[target met]), ALLSELECTED(Table1))
RETURN
IF(Percentage >= 0.66, "Met Target", "Not met target")

  

You may also refer to appendix.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[po]

Thanks for reply