Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |