Slicer selected value

[moussab_orabi]

Hi every body, I am trying to read value selected from Slicer and use it as filter value in query.

this is my query:

sum_gesamtpreis = CALCULATE(SUM(umsatz[gesamtpreis]);umsatz[kunde]="20006")

instead of writing the customer number I want to choose it directly from Slicer


Thanks for helping 🙂

[v-yuezhe-msft]

Hi @moussab_orabi,

Could you please share sample data of your table and post the result you want to get with the sum_gesamtpreis measure? In your scenario, you can just create sum_gesamtpreis using DAX below, this way, as other post, when selecting different values in customer number slicer, the value of sum_gesamtpreis measure will be changed based on selected customer number.

sum_gesamtpreis = SUM(umsatz[gesamtpreis])

Thanks,
Lydia Zhang

[moussab_orabi]

Hi Lydia ,
I have 3 steps report,
in the first two steps I have to set some filters and this filter should affect the results in the third step so I don't have to reset them again.

BR,
Moussab

[MFelix]

Hi @moissab_orabi,

To my knowledge this is not.possible everyone as this requirement search in the idea forum and vote for that option.

[MFelix]

Hi @mpissab_orabi,

If you are using the customer name as a slicer all your report visuals will be sliced/filtered to the ones that correspond to the value on the slicer and you don't need to add it to your measure.

Regards,
MFelix

[moussab_orabi]

Hi Felix,

Thanks for your replay.
what am I trying to do is making  slicer value readable from all reports sheets "pages" so  at the first page  I am trying to set the basics filters then this should affect  all the followed reports pages.

thats way I need to use it in the query.
BR,
Moussab

[ceebu]

As far as I know, you cannot have the value of a dynamically selected value,  as the filter for other report pages. 

I have the same requirement too, so if someone can share how, would be great.