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.
Hi Team,
I have a requirement where i have to display Failed and Error count on card visuals.
and the logic I got for Failed count is
Solved! Go to Solution.
Hi @SushmaReddy
Thanks for reaching out to us.
>> I have a requirement where i have to display Failed and Error count on card visuals.
You can try this split operation, it will contain the number of your errors
ErrorCount = CALCULATE(DISTINCTCOUNT(T1[Attribute]),T1[Status]="Failed")
FailedCount = CALCULATE(DISTINCTCOUNT(T1[Date]),T1[Status]="Failed")
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @SushmaReddy
Thanks for reaching out to us.
>> I have a requirement where i have to display Failed and Error count on card visuals.
You can try this split operation, it will contain the number of your errors
ErrorCount = CALCULATE(DISTINCTCOUNT(T1[Attribute]),T1[Status]="Failed")
FailedCount = CALCULATE(DISTINCTCOUNT(T1[Date]),T1[Status]="Failed")
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
did you split column in PQ?
based on the sample data, i think you can use count and distinctcount to get 2 and 1.
Proud to be a Super User!
Yes the column is splitted in PQ and i tried using count and distinct count but it didn't work...
maybe you can try this
Proud to be a Super User!
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |