Forum Discussion

StoryofData's avatar
StoryofData
Icon for Helper III rankHelper III
3 years ago

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...
Need Help
Tutorial Requests
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Here's my suggestion:

  1. Create a calculated column formula as follows
Combine = Table[CaseNumber]&"-"&Table[EmplId]&"-"&Table[ParticipantName]
  1. Write this measure

Count = calculate(distinctcount(Table[Combine]),Table[IemRoleInCase]="Subject")