Different DAX measures/formula on each row

[rbalza]

Hi Power Users,

Is there a way in DAX to have a calculation/formula on each rows? I have a few categories and I wanted to calculate each rows based on the categories given.  Say on revenue category I have DAX which is sum of all sales.  Debtor days, I have another dax measure, and goes on and on. I know its easy to use it in excel because we can have a different formula on each rows. Is there any way to do it in power bi? Thanks!

[amitchandak]

@rbalza , You can have.

Like

Measure =

Switch(true() ,

max(Table[Category]) = "SRevenue" , Sum(Table[val1]) ,

max(Table[Category]) = "WIP Days" , Sum(Table[val2]) ,

Sum(Table[val3])

)

or

Measure =

Sumx(Table,

Switch(true() ,

(Table[Category]) = "SRevenue" , (Table[val1]) ,

(Table[Category]) = "WIP Days" , (Table[val2]) ,

(Table[val3])

))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.