Measure in report causes filter not to apply to the data set

[Anonymous]

Hello,

I have created a measure in a report which has the following formula: 

var minC= min(vw_ReportTable[Customer])

return if(left(minC,4)="CINT",minC,"CustomerLabel"). After adding this measure to the data set the filters started not to apply to the data set anymore. All the data is displayed even if only one value is selected for a filter. It seems that somehow there is a cartesian product between the tables.   I have attached a sample report - https://ufile.io/kpzp23jf . Measure 1 is the measure which I added and the slicer is a hierarchy created from the columns from table H.

Has anyone come across this situation so far? It seems that any measure I create, which is not a calculation causes this behaviour.

Thank you.

[Anonymous]

Hello @selimovd , If you notice in this report ( https://ufile.io/43358l6h) , I have tables Data and H linked by the columns C1 and Column3 (picture 1) .

I have created a measure with the code: Measure1 = if ( max(Data[C4])= "Details 4", "External" ,"Internal")

If I add this measure in the table visual then the data from table D will not be filtered anymore - the data from Column3  table H) is filtered for Leaf1, which is the selected value (picture 2).

if I remove the measure from the table visual then it will get filtered (picture3).

1. 

2.

3. 

Thank you.

[selimovd]

Hey @Anonymous ,

the reason is how the DAX engine works.

The formula will be applied for all rows. Usually if the value is blank, then the row will not be shown. That's what you usually want.

In your case, the measure will return "Internal" in any case when max(Data[C4]) does not equal "Details 4". This also applies for all rows that return blank. So you have to only return a value when max(Data[C4]) is not blank. Try the following measure:

Measure1 = IF ( MAX ( Data[C4] ) <> BLANK(), IF ( MAX ( Data[C4] ) = "Details 4", "External" , "Internal" ) )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[selimovd]

Hey @Anonymous ,

your file doesn't fit your problem.

Please add the correct file and insert or post here the measure that you can just paste to reproduce your error.

In general, I never heard of a measure breaking a report.

Best regards

Denis