Forum Discussion
Column counting blank values
Issues with this dax as a column: Sanctions All (Participant Closed) = IF('Table'[IemRoleInCase] = "Subject", COMBINEVALUES ("-", [CaseNumber], [EmplId], [ParticipantName])) My column ap...
Have 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)])
)
or
Distinct Count =
CALCULATE(
DISTINCTCOUNT('Your Table'[Sanctions All (Participations All)]),
FILTER('Your Table',
NOT(ISBLANK('Your Table'[[Sanctions All (Participations All)]))
)