Slicer selected value

Question

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 :)

mfelix · Answer

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

anonymous · Answer

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 · Answer

Hi Felix,Thanks for your replay.what am I trying to do is making&nbsp; slicer value readable from all reports sheets "pages" so&nbsp; at the first page&nbsp; I am trying to set the basics filters then this should affect&nbsp; all the followed reports pages.thats way I need to use it in the query.BR,Moussab

moussab_orabi · Answer

&nbsp;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&nbsp;&nbsp;&nbsp;&nbsp;