Forum Discussion
Column counting blank values
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
4 Replies
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-p/963216
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/1447523Have you tried using a distinctcount measure to specificially exclude blanks and use it in a card?
Something like this:Distinct Count =CALCULATE(DISTINCTCOUNTNOBLANK('Your Table'[Sanctions All (Participations All)]))
orDistinct Count =CALCULATE(DISTINCTCOUNT('Your Table'[Sanctions All (Participations All)]),FILTER('Your Table',NOT(ISBLANK('Your Table'[[Sanctions All (Participations All)])))Hi,
Here's my suggestion:
- Create a calculated column formula as follows
Combine = Table[CaseNumber]&"-"&Table[EmplId]&"-"&Table[ParticipantName]- Write this measure
Count = calculate(distinctcount(Table[Combine]),Table[IemRoleInCase]="Subject")
Hi,
Here's my suggestion:
- Create a calculated column formula as follows
Combine = Table[CaseNumber]&"-"&Table[EmplId]&"-"&Table[ParticipantName]- Write this measure
Count = calculate(distinctcount(Table[Combine]),Table[IemRoleInCase]="Subject")
