Calculating ratio

[AleksiK]

Hello, I need help with calculating a ratio between row value and filtered sum. Here's an example:

Room	House	Area (m²)	Ratio
A	House 1	100	0,333333
B	House 1	200	0,666666
C	House 2	100	0,5
D	House 2	100	0,5
E	House 2	200	0,333333
F	House 3	200	0,333333
G	House 3	200	0,333333

I have this data with houses and rooms inside of them. I want to calculate this ratio column with DAX automatically which divides the area of room with total area of the house.

[Pragati11]

Hi @AleksiK ,

You can try something as below: (Created a RATIO measure as shown below)

Thanks,

Pragati

[Arklur · Accepted solution]

RoomAreaPerc = 
VAR vTotalHouseArea = 
    CALCULATE ( 
        SUM ( Data[Area] ),
        ALLEXCEPT ( 
            Data,
            Data[House]
        )
    )
RETURN
    DIVIDE ( Data[Area], vTotalHouseArea )

Add this column to the table.

If you need this as a measure, so filters should be taken into account, the DAX code needs to be changed slightly, but this should kick you off.

[amitchandak]

@AleksiK , what is the logic for ratio?