Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
@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.
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