Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

undefined

Can I create a sum measure from a measure? I have calculated the positive values from all values in the table visual with visual level filter but i want sum of positive values in card also. Is this ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

If you want to get the sum result of your measure in a card, I think you just need to pull your measure into the card, that will be fine.

 

If you want to use measure to do the positive calculation, you can try below measure:

positive measure = calculate([your_measure],[your_measure] >0)

 

Please try.

Aiolos Zhao

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for your reply @Aiolos Zhao

    I am getting this error.(A function CALCULATE has been used in a true/false expression that is used as a table filter expression. This is not allowed ) 😞

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

       

      Sorry, please try below measure, I make it in my report.

       

      CALCULATE([your_measure],FILTER('your_table',[your_measure] > 0))
       
      Aiolos Zhao