Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Display zero when is blank in Matrix to properly do the difference in Measure

Hi, I have this measure:       DELTA3 = VAR TOODAY = MAX('DATA BASE'[FECHA DE CAPTURA]) VAR YESTERDAY = MAX('DATA BASE'[FECHA DE CAPTURA]) - 1 VAR HOY = CALCULATE(SUM('DATA BASE'[Tons]),VALUES(...
Need Help
Show and Tell
Tips and Tricks
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    I am not sure your data structure and measure, you could refer to my sample for details. If this is not what you want, please correct me and inform me more detailed information (such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi amitchandak , thank you for your help, it actually worked but the sum it's still not accurate

Look for example the total of the first 2 rows.

I think it's because the program do the difference and then add the zeros, is there a way for put the zeros before the calculation.

 

Thank you for your help

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak tried this and also display the zeros but still no accurate calculation:

((HOY+0) - (AYER+0))

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous , 

    I am not sure your data structure and measure, you could refer to my sample for details. If this is not what you want, please correct me and inform me more detailed information (such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

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