Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a column with 3 different values, say low, normal and high, and I wanna make a KPI of each low, high and normal how many of them there are. I have use this below but get error.
Hi @okletsgo ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share your data sample and your desired output so that we could get your question quickly answered.
Best Regards,
Cherry
Hi buddy,
try use this:
Measure: CALCULATE(COUNTA([column1]); FILTER(Table;[column KPI]="High"))
Normally the filter formula ask you to say exactly what you want.
Any questions, ask 😉
User | Count |
---|---|
88 | |
88 | |
74 | |
68 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |