Problems taking % of total for a certain dimension

[Syndicate_Admin]

Hello.

I'm new to Power BI and I have a problem with getting the percentage of the total for a measure, that is, I have the following, when I get the percentage of the total for the operator measure, I don't have a problem, but when I get it for technology, I don't get it:

Here is the example that does give me correct, by operator

Here is the other scenario that does not work for me, since the "Total Traffic Tech [PB]" I cannot obtain the total traffic by technology, therefore the percentage does not give me the correct distribution.

Any help will be appreciated.

Best regards.

[Anonymous · Accepted solution]

Hi, @Syndicate_Admin 

Based on your information, I create a sample table:

Then create measure:

Percentage=
DIVIDE (
    SUM ( 'Traffic 2024'[Traffic PB] ),
    CALCULATE (
        SUM ( 'Traffic 2024'[Traffic PB] ),
        ALLSELECTED ( 'Traffic 2024'[Tech] )
    )
)

Here is my preview:

The field Traffic PB needs to be aggregated, otherwise the following problems will occur

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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

[RossEdwards]

Percentage Of Total Trafico Tech = 
var numerator = [Total Trafico Tech[PB]]
var denominator = CALCULATE([Total Trafico Tech[PB]], ALL('Traffic 2024[Tech])
RETURN
DIVIDE(numerator, denominator)