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 measure7calculated column/DAX?

 

Thanks.

B

 

 

Need Help
Tips and Tricks

7 Replies

      • 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

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    taurius2022 you can do both. How do you want to present the result?
    As a string in a measure? As a filter that will only show these values in a table?
    Let me know and I'll write the solution

    • taurius2022's avatar
      taurius2022
      Frequent Visitor
      4 years ago

      Hi SpartaBI ,

       

      ideally I would love to have a column which would be summing up energy

      a = o

      b = 28

      c = 0

      d = 7

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        4 years ago

        Hi,

        Drag Category to the Table visual and write this measure

        Measure = sum(Data[Energy])

        Hope this helps.