call field from slicer values in dax

[Sathvik123]

Hello All,

I have table having data like below with 3 trend types daily , weekly and monthly.

Now my requirement is I need to give an option to end user to select daily, weekly and monthly.( I cant take trendtype to filter directly as I am calculating quarterly in power bi dax)

So for this I created a table in power bi with values Daily, weekly and monthly and put them in slicer.

But I am not sure what is the dax command used here to call my trendtype values from table based on selected slicer value.

Could any one please help

[v-eqin-msft]

Hi @Sathvik123 ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Sathvik123 ,

Not very clear about this sentence: I cant take trendtype to filter directly as I am calculating quarterly in power bi dax.

And I tried to reproduce your scenario based on :So for this I created a table in power bi with values Daily, weekly and monthly and put them in slicer.

For Slicer = {"Daily","Weekly","Monthly"}

Then create a flag measure for visual-filter later:

Filter Flag = IF(MAX('Table'[TrendType]) in ALLSELECTED('For Slicer'[Value]),1,0)

Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Sathvik123 , You Take Date and Sum of Sales in a visual and Trend Type in a single select slicer and use that