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

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
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