Forum Discussion

s_mccafferty's avatar
s_mccafferty
Frequent Visitor
7 years ago
Solved

DAX: Calculate Percentages

I have a data model similar to the below: Building Occupier Area building 1 occupier1 10000 building 1 occupier 2 15000 building 2 occupier 3 10000 building 3 occupier 4 10000 building 3 occu...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi s_mccafferty ,

     

    Here we can create a measure to work on it.

     

    Measure =
VAR oc =
    CALCULATE ( SUM ( Table1[area] ) )
VAR al =
    CALCULATE ( SUM ( Table1[area] ), ALL ( Table1 ), VALUES ( Table1[Building] ) )
RETURN
    DIVIDE ( oc, al )

     

    Pbix as attached.

     

    Regards,

    Frank

ninalee's avatar
ninalee
Icon for Helper I rankHelper I
7 years ago

thnx, very helpful