Forum Discussion
Page level slicer filter without calculated columns
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.
- You can only use measure as a visaul filter not s page level filter because the measures make a line by line analisys so it will always return the smallest result. Only columns can be used in page level filters.
Regards,
Mfelix
4 Replies
- MFelix
Super User
Hi 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
Hi 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?
- MFelixYou can only use measure as a visaul filter not s page level filter because the measures make a line by line analisys so it will always return the smallest result. Only columns can be used in page level filters.
Regards,
Mfelix