Forum Discussion
Could you help me with the DAX function
Hi,
Does this measure work?
Measure 2 = if(max('Data Base'[Centro de Custo])="1 - Receitas Liquídas com Vendas",1,DIVIDE([M],[Measure]))
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,
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:
Sorry for the English, I use Google Translate.
Att.
Robson
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]))Ashish, good night!
Just one detail, how can I leave this field at 100%?
The rest worked perfectly.
Thank you very much.
Att. Robson
Hi,
Does this measure work?
Measure 2 = if(max('Data Base'[Centro de Custo])="1 - Receitas Liquídas com Vendas",1,DIVIDE([M],[Measure]))