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.
Hello dear.
I have a doubt in calculating the number of lines for Groups that have more than 5 Requests. In this case, I have an indicator that the total base is the number of distinct groups and of which there are more than 5 requests.
Example:
Group A: 2 Requests
Group B: 7 Requests
Group C: 6 Requests
Group 😧 1 Request
So, there are 4 groups and only two of them have more than 5 requests (>5).
So my indicator (speedometer) should show 50%.
---------------------------------------------------------------------------------------------------------
So far these are the calculations and commands I created, but they are not working:
1.) I did the calculation first to count the lines with a filter:
----------------------------------------------------------------------------------------------------------
2.) Then I calculated this row calculation to show which row has more than 5
- I think this is the problem with the calculation
---------------------------------------------------------------------------------------------
3.) Here's just the distinct groups I need, that's right
---------------------------------------------------------------------------------------------
Next is shown in the 25% indicator, it is incorrect. It should show 0%, since none of the groups presented more than 5 requests:
Could you help me with this calculation?
Thanks
Solved! Go to Solution.
Hi, @matiellu2
Try the codes below:
Count = DISTINCTCOUNT('Table'[Status])
Count>5 =
var tab=SUMMARIZE('Table','Table'[Status],"Count",COUNTROWS('Table'))
return CALCULATE(DISTINCTCOUNT('Table'[Status]),FILTER(tab,[Count]>5))
Percentage = [Count>5]/[Count]
Regards,
Ethan
Hi, @matiellu2
Try the codes below:
Count = DISTINCTCOUNT('Table'[Status])
Count>5 =
var tab=SUMMARIZE('Table','Table'[Status],"Count",COUNTROWS('Table'))
return CALCULATE(DISTINCTCOUNT('Table'[Status]),FILTER(tab,[Count]>5))
Percentage = [Count>5]/[Count]
Regards,
Ethan
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 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |