Forum Discussion

AndradeRobson's avatar
AndradeRobson
Icon for Helper II rankHelper 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 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

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    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]))

     

11 Replies

  • lucadelicio's avatar
    lucadelicio
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

    Hi,

     

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

    Thank you!

    • AndradeRobson's avatar
      AndradeRobson
      Icon for Helper II rankHelper II
      2 years ago

      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