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.
Hey Guys,
I'm requesting some help on building this measure....
I have 2 tables (an Events table and Rejects Table).
The Events table contains the total number of events that occurred for a certain location, time period, client, etc.
Events Table Example:
The Rejects table contains the count Rejects of the Events in the table above along with additional information such as what queue it was rejected the reject reason, etc.
Rejects Table Example:
All I'm trying to accomplish is getting the Rejects as a % of total Event volume.
I thought it would be as simple as dividing Rejects Count / Event Count.
Here's what I created....
Rejects as a % of Event Volume = CALCULATE(sum(Rejects_All2[COUNT(*)])/CALCULATE(sum('Events All'[COUNT(*)])))
But the calc is giving me an "infinity" %
Any idea on what I'm doing wrong with the calc?
Solved! Go to Solution.
I did a little bit of research and found a measure that works.....
I did a little bit of research and found a measure that works.....
Hi @zeke101
If you want to find the % of Rejectes based on the All Events, Try this:
Measure = COUNTROWS(Rejects_All2)/COUNTROWS(Events All)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @VahidDM
This wont work as it only counts the rows of the table, but each row value is worth more than 1. Notice how the tables have a "Count (*)" column. Those numbers need to be aggregated and then a calculation must be derived to create the percentage.
Hi @zeke101
Is there any relationship between those tables? if yes, which columns are connected to each other?
Try this measure:
Rejects as a % of Event Volume =
Var _ALL =SUM(Rejects_All2[COUNT(*)])
Var _REJ = SUM('Events All'[COUNT(*)])
return
_REJ/_ALL
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @VahidDM
Unfortunately, this measure did not work - Calc is still giving me an "infinity" %
I dont have a relationship between the 2 tables. Here is what the relationship Model looks like:
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |