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 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
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |