topic Adequate Percentile of share on a matrix in DAX Commands and Tips

Adequate Percentile of share on a matrix

JRVianna — Thu, 30 Nov 2023 16:29:49 GMT

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

Re: Adequate Percentile of share on a matrix

123abc — Fri, 01 Dec 2023 09:46:17 GMT

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))

Re: Adequate Percentile of share on a matrix

JRVianna — Fri, 01 Dec 2023 21:18:21 GMT

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))