Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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,
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.
Thanks for reply
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |