Forum Discussion
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 ...
Hi,
Im not trying to sum both together Im trying to return one or the other based on the data in the table.
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).