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.
Dear all,
I need to calculate the amount of repeated incidents per category and the incidents need to have a standard solution. I used the following formula to calculate it (I have blanked out the table names):
Solved! Go to Solution.
Thanks for your help! I altered your measure a little bit, and it works!
This is the measure I ended up using:
KPI = CALCULATE(( COUNT(Table[Brief Description (Details)])), FILTER(Table,[Standard solution] = "Yes" ) )
@Sharu ,
This issue may caused by one filter is affected by other filters in other visuals. To be general, you may modify measure like pattern below and check if the issue persists.
KPI = COUNTROWS ( FILTER ( ALL ( Table ), [Brief Description (Details)] = EARLIER ( [Brief Description (Details)] ) && [Standard solution] = "Yes" ) )
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 your reply! I created a new blank Power BI file and created this visual again while using your measure, but unfortunately I got the same result as before. Is there any other way to calculate the amount of repeating values?
Sharu
@Sharu ,
How about measure below?
KPI =
CALCULATE (
COUNT ( Table[Brief Description (Details)] ),
FILTER (
ALLEXCEPT ( Table, Table[Brief Description (Details)] ),
Table[Standard solution] = "Yes"
)
)
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 your help! I altered your measure a little bit, and it works!
This is the measure I ended up using:
KPI = CALCULATE(( COUNT(Table[Brief Description (Details)])), FILTER(Table,[Standard solution] = "Yes" ) )
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |