Total of measure

[veron1990]

Hello All,

I am begginer with Power Bi and i have the problem with Total for Measure. I need obtain sum of Measure2. I spent several hours on searching the answer and using several solutions from forum and youtube, but I didn't find the answer for my "sum".

Please find below link to my sample report.

MyReport

Thank you in advance.

[Phil_Seamark]

Hi @veron1990

This calculated measure gets pretty close.  I have attached my copy of the PBIX File.

Measure6 = 
    IF(
        ISFILTERED('Sheet1'[kraj]),
        --If not a total line then --
        [measure2],
        -- This is the calculation for the total line
        SUMX(
            ALLSELECTED('Sheet1'[kraj]),
            [measure2])
            )

[veron1990]

Hello Phil,

Thank you for your answer. Unfortunately your measure is working only for first level ("kraj"). if you go one level below, you have the same value. I need the measure that will be working for all hierarchy levels and filters.

[Phil_Seamark]

Can you please give an example of what you would like the total line to show when drilling takes place.

[veron1990]

When i drilling the hierarchy I would like to have total line for chosen level. It means:

1. For first level (kraj) your formula is working. It should be approximately -0.8.

2. For second level (miasto) it should be sum of measure2 for this level (~-1.45):

3. For last level it should be the sum of measure2 for third level (the same value as for level2 because of small number of data, but in "real" project it will be different value).