Forum Discussion

jlafond's avatar
jlafond
New Member
4 years ago
Solved

DAX Formula IF statement with Filter

Hey all, I am having difficulty writing a successful DAX formula, and wondered if someone could assist.   TableA and TableB are joined many-to-one in both directions on the field CampaignID (whole ...
Need Help
  • jlafond's avatar
    jlafond
    4 years ago

    Never mind. I was able to modify your solution a bit to make it work for me. All good now, thanks!

     

    I had to add one more VAR for the second field I wanted to filter by (Name). I then put your SUMX formula into a CALCULATE formula with multiple filters.

jlafond's avatar
jlafond
New Member
4 years ago

I'm ultimately trying to filter by the Name & CampaignID to get the correct RafflesCapped value.

 

Expected results from the sample table data in the original post:

Name                CampaignID       RafflesCapped

Jane Doe            2000                   6000

Jane Doe            4500                   2000

Jane Doe            5000                   8000

Jake Doe            1500                   6000

Jake Doe            2000                   3000

Joe Smith           4500                   8000

Joe Smith           5000                   1000

Jill Smith            3000                   6000

 

Hopefully that helped clarify any confusion.

jlafond's avatar
jlafond
New Member
4 years ago

Never mind. I was able to modify your solution a bit to make it work for me. All good now, thanks!

 

I had to add one more VAR for the second field I wanted to filter by (Name). I then put your SUMX formula into a CALCULATE formula with multiple filters.