Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all.
I'm trying very hard to not use calculated columns whenever possible, but don't know the limits to what I can do with measures.
Here's what I want to do: Create a visual level filter that removes all $0 items. So with a calculated column I would write a formula: =if(column1=0,0,1). Then I would use that column as a slicer and it would properly filter everything that is $0 on the page.
Is there a way to do this? Any advice I could get for learning purposes would help. Thanks.
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous,
The measures are calculated in the context of the visual you use so if you show item at a row level measure will be calculated accordingly, if you do it at a group level it will be calculated at that level without looking at other values, so taking this into account you cannot use them so if in your visual the column for wich you are making the measure is not entered the filter will not show any values.
If you don't want to do this you need to use the filter function on your measures and then apply the Validation = 1 to return only the true values.
Regards,
Mfelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix, thank you for responding. I'm still unclear if I can use a Measure to do a page-level filter, so that it affects all other visuals on the page. Is that possible or do I need to use a calculated column?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsGot it. thank you very much for expalining this to me.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |