Forum Discussion
Slicer selected value
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") i...
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
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
- Hi @moissab_orabi,
To my knowledge this is not.possible everyone as this requirement search in the idea forum and vote for that option.
