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

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