Forum Discussion
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 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
Hi SpartaBI ,
ideally I would love to have a column which would be summing up energy
a = o
b = 28
c = 0
d = 7
Hi,
Drag Category to the Table visual and write this measure
Measure = sum(Data[Energy])
Hope this helps.
