Forum Discussion

pedrostt8's avatar
pedrostt8
New Member
2 years ago
Solved

dax

Boa tarde.

 

Estou com um problema, tenho uma meta definida porém no mês que não tem realizado o visual fica em branco, tem alguma dax que eu faça para que quando não ter realizado ele preencha com 0 para que eu consiga realizar o calculo e mensurar quando não ter realizado no mês ?

Help, please!!!!

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi pedrostt8 ,

    I create a table as you mentioned.

    Then I create a measure and here is the DAX code.

    Achieve = MAX('Table'[Achieve1])

    It shows Achieve is blank, so I create another measure.

    Measure = IF('Table'[Achieve]=BLANK(),0,'Table'[Achieve])

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi pedrostt8 ,

    I create a table as you mentioned.

    Then I create a measure and here is the DAX code.

    Achieve = MAX('Table'[Achieve1])

    It shows Achieve is blank, so I create another measure.

    Measure = IF('Table'[Achieve]=BLANK(),0,'Table'[Achieve])

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • pedrostt8's avatar
      pedrostt8
      New Member
      2 years ago

      Anonymous  thank you very much have a good day !!!!