March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
89 | |
84 | |
70 | |
51 |
User | Count |
---|---|
206 | |
143 | |
97 | |
79 | |
68 |