Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Different Calculation Based on Value In Column

Hi,   I have a measures table that contains the below columns   KPI Name Numerator Denominator IsRate   I would like to create a single Measure in Power BI that calculates a summarized value...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , try like

     

    sumx(Table, if(Table[IsRate] = "No", SUM(Table[Numerator]),SUM(Table[Numerator])/SUM(Table[Denominator]))

    or

    if(max(Table[IsRate]) = "No", SUM(Table[Numerator]),SUM(Table[Numerator])/SUM(Table[Denominator]))

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , try like

 

sumx(Table, if(Table[IsRate] = "No", SUM(Table[Numerator]),SUM(Table[Numerator])/SUM(Table[Denominator]))

or

if(max(Table[IsRate]) = "No", SUM(Table[Numerator]),SUM(Table[Numerator])/SUM(Table[Denominator]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak That worked. Thanks!