Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a measure called 'ALERT':
Solved! Go to Solution.
Hi,
According to your description, I can roughly understand your requirement, you want to get the sum of the [Alert] to display it in a bar chart, right? I think you can try my steps:
This is my test data:
You can create a calculated column
Alert =
IF([Group1]>=[Group2],0,1)
Then you can create a measure:
Measure =
SUM('Table'[Alert])
And you can go to create a bar chart to place it like this to get what you want.
You can download my test pbix file below
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
According to your description, I can roughly understand your requirement, you want to get the sum of the [Alert] to display it in a bar chart, right? I think you can try my steps:
This is my test data:
You can create a calculated column
Alert =
IF([Group1]>=[Group2],0,1)
Then you can create a measure:
Measure =
SUM('Table'[Alert])
And you can go to create a bar chart to place it like this to get what you want.
You can download my test pbix file below
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@@SoporteB , Try measure like
sumx(Table, Switch(true() ,
[Group1] > [Group2],0,
[Group1] = [Group2],0,
[Group1] < [Group2],1
) )
User | Count |
---|---|
51 | |
36 | |
20 | |
14 | |
13 |
User | Count |
---|---|
94 | |
72 | |
30 | |
21 | |
13 |