Getting values with 0 only from a table

[taurius2022]

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

[James-Harpin]

@taurius2022 

[SpartaBI]

@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]

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]

Hi,

Drag Category to the Table visual and write this measure

Measure = sum(Data[Energy])

Hope this helps.

[amitchandak]

@taurius2022 , A new measure

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

[taurius2022]

hi @amitchandak 

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

Best

[v-shex-msft]

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