Forum Discussion

taurius2022's avatar
taurius2022
Frequent Visitor
4 years ago

Getting values with 0 only from a table

Hi,   I have the following data set:         I want to get only categories, which have 0 kwh for the whole period of time (e.g. category "a"). Is there any option to do so through measu...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
4 years ago

taurius2022 , A new measure

 

calculate(sum(Table[energy]),filter(Table, Table[energy] 0) )

  • taurius2022's avatar
    taurius2022
    Frequent Visitor
    4 years ago

    hi amitchandak 

     

    thank you !
    I tested it and am looking at how I can work with it further.

    Best

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi taurius2022,

      Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

      If these also don't help, please share more detailed information to help us clarify your scenario to test.

      How to Get Your Question Answered Quickly 

      Regards,

      Xiaoxin Sheng