measure with multiple filters

[abukapsoun]

Hi Dears,

I have the following case 

Column 1   Column 2

1                  NA

1                  NA

2                  X

3                  Y

4                  NA

4                  NA

I want to count the number of "NA" with a filter on distinct on column1. So the count of NA return a value = 2 and not 4

Thanks,

Mohamed

[Datatouille · Accepted solution]

Hi,

You need to create the following measures:

Dsct = Distinctcount(YourTable[Column1])
DsctNA = Calculate ( [Dsct] , YourTable[Column2] = "NA")

[Eric_Zhang · Accepted solution]

You can just create a measure as

distinct CNT = DISTINCTCOUNT(Table2[Column1])

[Datatouille · Accepted solution]

Hi,

You need to create the following measures:

Dsct = Distinctcount(YourTable[Column1])
DsctNA = Calculate ( [Dsct] , YourTable[Column2] = "NA")