Forum Discussion

Max_mutant's avatar
Max_mutant
New Member
8 years ago
Solved

DAX Syntax for If Statement with Filter

Hello Everyone,   Here's what I am trying to do.   Right now I have a measure thats pulling back import duties based on a country.   msr_221ImportDutyRate = If (ISFILTERED('Trade Compliance'[Gr...
  • Max_mutant's avatar
    Max_mutant
    8 years ago

    Thanks that works.


    My assumption is you can't compare multiple columns in an if statement?

kcantor's avatar
kcantor
Community Champion
8 years ago

Max_mutant

Your measure does refer to two columns. Exporter and Product. Have you considered using your measure inside a calculate and using your filter there?

msr_221ImportDutyRate = If (ISFILTERED('Trade Compliance'[Grower Country (Exporter)]) && HASONEVALUE('Trade Compliance'[Grower Country (Exporter)]), CONCATENATEX(VALUES('Trade Compliance'[Item Duty Rate]),[Item Duty Rate],", ",[Item Duty Rate],ASC),"")

msr_221ImportDutyRateWithProductFilter =CALCULATE([msr_221ImportDutyRate], FILTER('TradeCompliance','TradeCompliance'[Product]="Lettuce"))

Max_mutant's avatar
Max_mutant
New Member
8 years ago

Thanks that works.


My assumption is you can't compare multiple columns in an if statement?

  • kcantor's avatar
    kcantor
    Community Champion
    8 years ago

    I think it was more along the lines of having too many "ands" involved without nesting the if statement.