Adequate Percentile of share on a matrix

[JRVianna]

Hi, I need to fix this code DAX to exibit the last image below:

% Share vendas brutas Agrupável =
VAR AllVendasBrutas =
CALCULATE ( [Vendas Brutas], ALL ( dLocalidades ) )
RETURN
DIVIDE ( [Vendas Brutas], AllVendasBrutas )

Before:

I need the measure to show the share like this image bellow

The share for continent is working, but I need that the share for category shows values that sum is 100%

Any doubts, reply this post. Thanks

[123abc · Accepted solution]

To achieve this, you can use a different approach for calculating the % Share vendas brutas Agrupável for categories. You want the sum of this measure to be 100% for each category. Here's a modified version of your DAX code:

% Share vendas brutas Agrupável =
VAR AllVendasBrutas =
CALCULATE([Vendas Brutas], ALL(dLocalidades))

VAR TotalSalesByCategory =
CALCULATE([Vendas Brutas], ALLEXCEPT('YourTable', 'YourTable'[Category]))

RETURN
DIVIDE([Vendas Brutas], IF(ISFILTERED('YourTable'[Category]), TotalSalesByCategory, AllVendasBrutas))

[JRVianna]

It didn't work, but with a slightly change it works

% Share vendas brutas Agrupável =

VAR ShareContinente =

CALCULATE([Vendas Brutas], ALL(dLocalidades))

VAR ShareCategoria =

CALCULATE([Vendas Brutas], ALL(dCategoriaProdutos[Categoria]))

RETURN

DIVIDE([Vendas Brutas], IF(ISFILTERED(dCategoriaProdutos[Categoria]), ShareCategoria, ShareContinente))