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
Mark_Timson's avatar
Mark_Timson
Helper I
7 years ago

Hi Akhil,

 

Thanks for replying. My result set isnt actually based off of these y or n values its more like an expression on the data. Its originally from business objects. Below is an extract from what I am trying to reproduce in power bi. 

 

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