Forum Discussion

Icon for Helper II rank

Helper II

2 years ago

Solved

Could you help me with the DAX function

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 expe...

2 years ago

Hi,

Does this measure work?

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

Icon for Impactful Individual rank

Impactful Individual

2 years ago

Hi,

upload the pbix i will help you!

Thank you,

Icon for Helper II rank

Helper II

2 years ago

Lucas, good night!

Below is the pbix file.

Thanks.

https://we.tl/t-OjQ1C0640J

lucadelicio
Impactful Individual
2 years ago
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
  Helper II
  2 years ago
  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
    Super User
    2 years ago
    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]))