Sum of values

[sonam7]

Hello everyone

I have the following table in Excel, I'm trying to do the same in PowerBI, but the result is not as expected.

I've created a measure for UnitsbyType

UnitsbyType á IF(MAX('MASCI vwEnvironments'[Type]) á "HC4",[Total Envs]*4,IF(MAX('MASCI vwEnvironments'[Type]) á "HC8", [Total Envs]*8,IF(MAX('MASCI vwEnvironments'[Type])'"HC12",[Total Envs]*12,IF(MAX('MASCI vwEnvironments'[Type]) á "HC16",[Total Envs]*16,[Total Envs]*1))))

Next I want to calculate total units as in Excel by adding UnitsByType for each branch, i.e. Prod, ASDB, ProdNext, etc. This is what I'm trying to do, but it doesn't give me the right value.

Total Units - SUMX(Summarize('MASCI vwEnvironments','MASCI vwEnvironments'[Branch]),[UnitbyType])

Can someone please help me with how I get these values in Excel?

Thank you

[v-yuta-msft]

@sonam7 ,

There's syntax error in the measure you post and the snapshots are not clear to see. Could you please give the expected result?

Regards,

Jimmy Tao

[amitchandak · Accepted solution]

@sonam7 , Assume you measure is M1 and Group by is Type

Try new measure like

sumx(summarize(Table,Table[Type],"_1", [M1]),[_1])