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.
Issues with this dax as a column:
My column appears correctly when in a table format:
But when I place it into a card and count distinct, it counts the blank fields
What is the issue with this?
Dax with blank at the end has the same issue
Hi,
Here's my suggestion:
Combine = Table[CaseNumber]&"-"&Table[EmplId]&"-"&Table[ParticipantName]
Count = calculate(distinctcount(Table[Combine]),Table[IemRoleInCase]="Subject")
Hi,
Here's my suggestion:
Combine = Table[CaseNumber]&"-"&Table[EmplId]&"-"&Table[ParticipantName]
Count = calculate(distinctcount(Table[Combine]),Table[IemRoleInCase]="Subject")
Have you tried using a distinctcount measure to specificially exclude blanks and use it in a card?
Something like this:
or
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
86 | |
75 | |
69 | |
68 |
User | Count |
---|---|
220 | |
128 | |
117 | |
82 | |
77 |