Forum Discussion

sonam7's avatar
sonam7
Microsoft Employee
6 years ago
Solved

Indefinite

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('MAS...
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi sonam7 ,

     

    You may create a measure like DAX below .

     

     

    Total Units=

VAR _table = SUMMARIZE( 'MASCI vwEnvironments', 'MASCI vwEnvironments'[Branch], "_Value", [UnitbyType])

RETURN

IF(HASONEVALUE('MASCI vwEnvironments'[Branch]), [UnitbyType], SUMX(_table,[_Value]))

     

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
6 years ago

Assume your measure is M1 and group by is type, try like

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