Forum Discussion
I need to create a slicer in AAS model
Hi, Currently, I'm trying to create a slicer to filter depending on one or more conditions to get " active / inactive " suppose you have a product and it's on sale and it's sold = active /...
Hi,
Thank you for respond.
Since, I'm using AAS model
I guess I will have to use adding a new column in SSMS and deploying to AAS model, finally I can use that calculated column in power bi to get the result in slicer.
So, this is close to your first solution (1.) right ?
HI Anonymous,
In fact, calculated columns can't get the selection from filters, their results will be fixed and not respond with filters. So measure filter can be a choice for your scenario, you can add conditions in the measure expression and return flags, then use the flag to filter records.
Regards,
Xiaoxin Sheng