Dax measure not working with filters

[Anonymous]

Hi,

I have created this measure on multiple datasets with no issue, but for some reason I can not get it to work on the dataset I'm currently working on.

I am trying to calculate the number of records in the "Review" workflow status - though if I filter for another status I expect the card to show null.

It does not matter what Workflow Status I filter for, but the number of record in "Review" stays the same.

I have moved the table over to a new PBI file and this is still occuring, there are no other relationships as it is just the 1 table in this new file.

[amitchandak · Accepted solution]

@Anonymous , If the filter is from same table 

then try like

calculate(countdistinct(Query1[record Number]), Filter(Query1, Query1[WorkFlow Status] = "Review" ))

if you want from a table that is not joined

calculate(countdistinct(Query1[record Number]), Filter(Query1, Query1[WorkFlow Status] in allselected(Query2[Workflow Status])))

[Anonymous]

Hi @amitchandak

The top formula works 🙂

Thought just out of curiosity, do you know why my formula was not working?

I have checked and used it in other datsets, so I'm not sure what is different about the current dataset.