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.
I want to be able to add a filter to the measure so that any date that has $0, doesn't show.
Or
would it be easier for me to filter them in the visual, If so how would I do that?
Thanks to anyone that helps
Solved! Go to Solution.
Hi @SteelChampzz
You can try
Amount2 =
VAR Amount = [Amount]
RETURN
IF ( Amount > 0, Amount )
Hi @SteelChampzz
You can try
Amount2 =
VAR Amount = [Amount]
RETURN
IF ( Amount > 0, Amount )
That worked PERFECTLY!
thank you
User | Count |
---|---|
57 | |
48 | |
18 | |
16 | |
15 |
User | Count |
---|---|
116 | |
42 | |
41 | |
27 | |
21 |