Could you help me with the DAX function

[AndradeRobson]

Dear all, good evening!

I need help.

I have a table called:
2000_Razao_Centro_Custo_Empresa_A

Columns
- Cost Center
- Date
- R$ Movement

Goal:

In other words, the value of each expense cost center must represent how much of the Total Revenue it consumes.

But when I try to do this the result is this below.

The dax function I created was this:

Can you help me.

Att.

Robson

[lucadelicio]

Hi,

can you share an excel data example file to help you?

Thank you!

[AndradeRobson]

Luca, good afternoon!

Thanks for the feedback.

Below is an example of the Excel database.

There will be two spreadsheets in the file:
1st Spreadsheet: Example database
2nd Spreadsheet: PivotTable with the objective to be achieved in Power BI

Thanks.

I didn't find a place to insert a spreadsheet. Could you send me your email to send the model file.

Att.

Robson

[lucadelicio]

Upload the pbix on https://wetransfer.com/
Thank you!

[AndradeRobson]

He follows.

https://we.tl/t-3eH7hFylmf

[lucadelicio]

Hi,

upload the pbix i will help you!

Thank you,

[AndradeRobson]

Lucas, good night!

Below is the pbix file.

Thanks.

https://we.tl/t-OjQ1C0640J

[lucadelicio]

Hi Andrade,

in the pbix 1 - Receitas Liquídas com Vendas is 5.966 and not 2.500 like you post.
Another question can you specify exactly the operation you do to find the 100% for the first row and the 15% for the second row?
So i will help you!
Thank you,

[AndradeRobson]

Lucas, good morning!

The first post was an example.

Please consider the pbix file and the new excel in the link below with the database, details and summary in the spreadsheets.

Below is a demonstration in Excel of the objective to be achieved in Power BI:

https://we.tl/t-XmkMbEsbU9

Sorry for the English, I use Google Translate.

Att.

Robson

[Ashish_Mathur]

Hi,

These measure work

M = SUM('Data Base'[Movimento])

Measure = CALCULATE([M],'Data Base'[Centro de Custo]="1 - Receitas Liquídas com Vendas",all('Data Base'[Conta Contábil + Descrição]))

Measure 2 = if(max('Data Base'[Centro de Custo])="1 - Receitas Liquídas com Vendas",BLANK(),DIVIDE([M],[Measure]))

[AndradeRobson]

Ashish, good night!

Just one detail, how can I leave this field at 100%?

The rest worked perfectly.

Thank you very much.

Att. Robson

[Ashish_Mathur · Accepted solution]

Hi,

Does this measure work?

Measure 2 = if(max('Data Base'[Centro de Custo])="1 - Receitas Liquídas com Vendas",1,DIVIDE([M],[Measure]))