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.
Hi All,
I want to count the number of distinct records based on the category column.
This is the calculation I have done
I would like this to displayed be in a card visual:
e.g. Select Category = 2
Premium Category = 2
Basic Category = 4
Group | Type | Category |
ABC | GEN | Select |
ABC | GEN | Premium |
ABC | GEN | Premium |
ABC | GEN | Basic |
ABC | GEN | Basic |
ABC | GEN | Basic |
ABC | GEN | Basic |
ABC | GEN | Select |
Please can someone advise? Thanks in advance
Solved! Go to Solution.
@Anonymous , To me this seem count
count(Table1[Category])
There is not distinct value column I can see here, if there is one you can try like
Measure =
Sumx(Values(Table1[Category]), calculate(
DISTINCTCOUNT(Table1[ID]))
)
Hi @Anonymous
As you mentioned you want to display all value in cards. Since you have multiple categories so you have to use multi-row card visual.
Under that visual you can directly drag your category and take a count of it.
PFA screenshot for reference:-
Thanks
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @Anonymous
As you mentioned you want to display all value in cards. Since you have multiple categories so you have to use multi-row card visual.
Under that visual you can directly drag your category and take a count of it.
PFA screenshot for reference:-
Thanks
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hey @Anonymous ,
your ALLEXCEPT doesn't make sense.
Try it without and it should work:
Measure =
CALCULATE(
DISTINCTCOUNT(Table1[Category])
)
@Anonymous , To me this seem count
count(Table1[Category])
There is not distinct value column I can see here, if there is one you can try like
Measure =
Sumx(Values(Table1[Category]), calculate(
DISTINCTCOUNT(Table1[ID]))
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
82 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
111 | |
110 | |
72 | |
71 |