Show percentage of parent total - Matrix Visual

[justivan]

Hello,

To be honest, I'm not really sure if what I'm trying to do is possible at all. What I'm trying to do is show the percentage based on the parent total but I want the parent total to display the actual value. Say for example, Address Beach have a total of 500 room night produced in which client2 contributed 96.6% on that 500 room nights. I'm not really sure how to approach this in power BI I just generated this in excel pivout's table and showed the value as % of Parent Total. Is this doable in matrix visual?

Thank you in advance!

[Fowmy · Accepted solution]

@justivan 

You can do it this way but using the FORMAT function. I sed a sample data set in Power BI, you can replicate the same for your data.

% of Total = 
IF(
    ISINSCOPE(financials[Segment]),
        
    DIVIDE(
        [Total Sales],
        CALCULATE(
            [Total Sales],
            ALLSELECTED( financials[Segment] )
        )
    ),
    FORMAT( [Total Sales], "#,#0" )
)

[justivan]

Hi @Fowmy ,
This is it! I tried using IF and ISFILTERED to identity the hierarchy then do the calculations according to the result but have given up because of the formats. Parent is number so the child are showing decimals. I didn't know you can do it that way. I'll certainly look into that ISINSCOPE function but if you could tell me, is ISFILTERED  a valid approach too? Thank you so much for this!

[Fowmy]

@justivan 
You can use ISFILTERED but if you insert a slicer with Segment, the measure would not give you the expected results. ISINSCOPE check if the column is grouped within the query.

Find more details here: https://dax.guide/isinscope/