Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX IF OR Statement

Hi All - I'm new to PowerBI and the community and could really use some help with a DAX IF statement which I am stuck on.   I have a simple table with two columns (SiteId and Att Rate) and wish to ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    Try replacing your SUM(s) with MAX(s)?
fhill's avatar
fhill
Resident Rockstar
6 years ago

Does this have to be a Measure?  Here's the logic with a New Column instead?

 

New Column = IF(Table1[SiteID] = 28 || Table1[SiteID] = 52, .1, Table1[Rate])
 
fhill's avatar
fhill
Resident Rockstar
6 years ago

P.S.  Measure version if needed...

 

New Measure = IF( SUM(Table1[SiteID]) = 28 || SUM(Table1[SiteID]) = 52, .1, SUM(Table1[Rate]))