100%

Mate provide some sample data or your PBI file, cant do anything without sample data

Hi Anonymous ,

In response to your question, I did some preliminary research on it.

You can make a measure at first to calculate the ratio of each value relative to the total for Austria.

RatioToSubcategory = 
    SUM(Table[Value]) / CALCULATE(
        SUM(Table[Value]),
        ALL(Table),
        Table[Country] = "Austria"
    )

To ensure that Austria shows as 100%, you can modify the formula as follows:

AdjustedRatioToSubcategory = 
    IF(ISFILTERED(Table[Country]) && Table[Country] = "Austria",
        1,
        [RatioToSubcategory]
    )

Similarly, you can create a measure for Volvo’s market share:

VolvoMarketShare = 
    SUM(Table[VolvoValue]) / CALCULATE(
        SUM(Table[Value]),
        ALL(Table),
        Table[Country] = "Austria"
    )

But if you provide me with specific data and pbix files, I can do more in-depth research to help you solve the problem.

How to Get Your Question Answered Quickly 

Best Regards

Yilong Zhou

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

hi Anonymous ,

Please replace table and column names with yours.

Measure

PctOfTotal =

VAR _TotSales = CALCULATE(SUM(TestTbl1[Sales]), ALLSELECTED(TestTbl1[Country]), ALLSELECTED(TestTbl1[Region]))

VAR _CountryRegionSales = CALCULATE(SUM(TestTbl1[Sales]))

RETURN DIVIDE(_CountryRegionSales, _TotSales, BLANK())