Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@taurius2022 , A new measure
calculate(sum(Table[energy]),filter(Table, Table[energy] 0) )
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
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |