CODEWITHSUNDEEP
powerbidaxmeasure
Ashna
Ashna

Reputation: 1

power bi DAX measure not corresponding against date

I have made a measure as

CALCULATE((COUNT('Raw Data'[Work Item ID])),'Raw Data'[BWV Footage Available] = "No",'Raw Data'[No BWV Reason] <> "No Reason",'Raw Data'[Month Year Complaint closed] <> blank())

But when i put this measure in the values against the date, it shows the same value throughout - it doesn't filter corresponding to the date. enter image description here

Please help

Upvotes: 0

Views: 157

Answers (1)

Marco Vos
Marco Vos

Reputation: 2968

The problem is the Raw Data'[Month Year Complaint closed] <> blank() part in your CALCULATE function. This 'filter' on the [Month Year Complaint closed] column, which returns all rows where this field is not BLANK, overrides the filtering of the same column in your visual ([Month Year Complaint closed] on rows). Remove this part from your maesure and filter out the Blank row in your visual.

Upvotes: 1

Related Questions