Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Community,
I am trying to filter out some values by using DAX.
Column A Column B
A (blank)
B 0
C 1
D 2
How do I filter out (blank) and 0 in column B.
Thanks.
Thanks
Solved! Go to Solution.
@Calvin . If you need a new measure
C = calculate(Sum(Table[Column B]), Filter(Table, Table[Column B] <>0 && not(Isblank(Table[Column B]) ) ) )
@Calvin . If you need a new measure
C = calculate(Sum(Table[Column B]), Filter(Table, Table[Column B] <>0 && not(Isblank(Table[Column B]) ) ) )
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |