Forum Discussion
taurius2022
4 years agoFrequent Visitor
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...
taurius2022
4 years agoFrequent Visitor
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
4 years agoSuper User
Hi,
Drag Category to the Table visual and write this measure
Measure = sum(Data[Energy])
Hope this helps.