Forum Discussion
jakubk
Helper I
Helper ICard showing wrong rowcount. whatif filter ignored
my data source is star schema datamart i have a simple viz that's filtered by slicers based on dimension attribute values i also have a whatif param that i'm using to filter the viz to only records...
jakubkHelper I
Helper Iok, so its still very fiddly with having to create not obvious custom filtered measures
isn't there a way to create a boolean flag and use that as filter?
eg
Column = if(Data[Quantity]<=SELECTEDVALUE('Quantity Filter'[Quantity Filter]), true, false)
i tried but it always returns false
PaulDBrown
Community Champion
Community ChampionIt won't work. Calculated columns are not dynamic. They are calculated when the table is loaded and are immune to slicers and filters
- jakubk
ahhh
And I can't add a boolean as a measure and filter on it because if this bug (already tried) - https://community.powerbi.com/t5/Desktop/BOOLEAN-column-can-t-apply-filter-in-Power-BI-Desktop/td-p/58800
thanks for the info