Forum Discussion
AndradeRobson
2 years agoHelper II
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]))
Ashish_Mathur
2 years agoSuper User
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
2 years agoHelper II
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_Mathur2 years agoSuper User
Hi,
Does this measure work?
Measure 2 = if(max('Data Base'[Centro de Custo])="1 - Receitas Liquídas com Vendas",1,DIVIDE([M],[Measure]))