DAX problem, filter/relation ignored when I use IF in the RETURN clause

[Anonymous]

I have two test tables:

Table: "Test Object"

Table: "Test Group"

These have a unidirectional relation on "Group code"

I have created a measure "Test measure":

This gives the correct result:

NB: I have a page filter to only show Group Code "G01".

But it goes wrong when I use an IF function:

I then get the following result. Apparently the relation seems to be ignored now:

NB: The result doesn't change when I use the "Group code" from any of the two tables.

It's probably a basic / dumb mistake, but right now I don't see it. What am I missing here?

NB: I've created a PBIX file that shows the problem:

https://www.dropbox.com/s/76ld1kv503ul6nm/DAX%20problem%20with%20IF.pbix?dl=0

[amitchandak]

@Anonymous , check that the group code in the visual is taken from Test Object table

[Anonymous]

I've tried that. The result doesn't change if the Group code is coming from any of the two tables.

[amitchandak]

if group code coming from two table. Create the formula on master/dimension table(1 side) and use that in visual

Can you share a sample pbix after removing sensitive data.

[Anonymous]

https://www.dropbox.com/s/76ld1kv503ul6nm/DAX%20problem%20with%20IF.pbix?dl=0

[Icey · Accepted solution]

Hi @Anonymous ,

Try to create measure like so:

Price category = 
VAR lowestPrice =
    MIN ( Object[Price] )
RETURN
    IF ( lowestPrice <> BLANK (), 
       IF ( lowestPrice < 40, "Low end", "High end" ) 
       )

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.