Pass selected slicer value(Text) into a measure
Hi, *I'm using Report Server Desktop "RS". I have a slicer that shows text values instead of numbers. I would like to create a measure that takes the selected "text"value(Column A) in a slicer, filters Column B based on the selected value in Column A. Then returns a "count" or "distinct count" of the filtered rows. I tried building a measure but I'm returned with a message "Cannot convert value XXXX of type Text to type Number". This seems like a simple formula but I'm not using the right syntax for DAX. Heres a table example: Column A-Slicer filters on this column Dog Cat Mouse Horse Column B PitBull Corgi Tabby Cat Jack Russell Thank you
Saving filter selections per user in Report Server
Hi All I have a report in Report Server and it contains a filter pop-up containing many slicers. My users would like the system to remember the last value on applied slicers so they won't need to apply then again when they open the report next time. Doesn't PowerBI use cookies for that? If not, what solution world you recommend? Thank you