Percent of subtotal

[Anonymous]

Current: (Picture 1) %CT of Total units shows % of the entire column(3000)

Wanted: (Picture 2) %of CT to show % of the Subtotal (1000) 

[v-deddai1-msft · Accepted solution]

Hi jhakak_ rawat,

You can use the HAVEONEVALUE function to determine whether you are currently evaluating a subclass or a parent class:

%CT =

IF (

    HASONEVALUE ( 'Table 1'[product] ),

    CALCULATE ( SUM ( 'Table 1'[total units] ) )

        / CALCULATE (

            SUM ( 'Table 1'[total units] ),

            ALLEXCEPT ( 'Table 1', 'Table 1'[category], 'Table 1'[date] )

        ),

    CALCULATE (

        SUM ( 'Table 1'[total units] )

            / CALCULATE (

                SUM ( 'Table 1'[total units] ),

                ALLEXCEPT ( 'Table 1', 'Table 1'[date] )

            )

    )

)

For more details, please refer to pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EUIuRUSs1axOiRw8Hk...

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

Best Regards,

Dedmon Dai

[marukosu]

Very hepful!!! 👏👏👏

[Yvaine233]

Thanks. very helpful.

[amitchandak]

@Anonymous 

Refer to this :https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

Appreciate your Kudos.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907