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

     

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

    Hi,

    upload the pbix i will help you!

    Thank you,


      • lucadelicio's avatar
        lucadelicio
        Icon for Impactful Individual rankImpactful 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,