Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Leave sub total empty when rows are empty

Hello everyone,   In my matrix table, I compare the cost price (Cost) with the selling price (Revenue) per car, but also per part of the car.  I want to have a measure for the difference between th...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Anonymous 

     

    You can try this measure

    difference = IF(COUNTBLANK('Table'[Revenue]) > 0, BLANK(), SUM('Table'[Revenue])-SUM('Table'[Cost]))

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi Anonymous 

 

You can try this measure

difference = IF(COUNTBLANK('Table'[Revenue]) > 0, BLANK(), SUM('Table'[Revenue])-SUM('Table'[Cost]))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.