Forum Discussion

Mark_Timson's avatar
Mark_Timson
Helper I
7 years ago

How to Sum based on an if statement

Hi all,   I was wondering if it was possible to do something similar to the below in power bi   IF Table.Col = "Y" THEN SUM(Table1.Col) ELSE IF Table.Col = "N" THEN SUM(Table2.Col) ELSE 0.   I ...
Need Help
AkhilAshok's avatar
AkhilAshok
Solution Sage
7 years ago

Have you tried the 2nd option which I mentioned?

Mark_Timson's avatar
Mark_Timson
Helper I
7 years ago

Hi, 

 

Im not trying to sum both together Im trying to return one or the other based on the data in the table. 

  • AkhilAshok's avatar
    AkhilAshok
    Solution Sage
    7 years ago

    What is the type of object in BO Universe? Is it created as a measure or dimension or detail? If it is created as a measure, and if the Projection setting of the object is Sum, then it should work the same way as I showed using DAX, since the entire logic gets summed up at the report level (both Y and N cases).

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Mark_Timson ,

    If it is convenient, could you share your data sample and your desired output so that we could help further on it?

    Best  Regards,

    Cherry