Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 /...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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