cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

New Member

## Adequate Percentile of share on a matrix

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

1 ACCEPTED SOLUTION
Community Champion

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 =

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

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

2 REPLIES 2
Community Champion

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 =

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

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

New Member

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

% Share vendas brutas Agrupável =
VAR ShareContinente =

VAR ShareCategoria =
CALCULATE([Vendas Brutas], ALL(dCategoriaProdutos[Categoria]))

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

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors