Forum Discussion
Solved
Filter Using a Slicer With No Relational Table
Good day, I am trying to filter my data like you would do in SSRS by using a paramter. I want to see Site Visits to Clients base on a Slicer Value. I have the Main Table with client, and a calcula...
Hi,
Here is one way to do this:
Data:Parameter:
VisitFilter = GENERATESERIES(0, 20, 1)
Visit measure =
Visit neasure = COUNT(Visits[Visit]) //using simple count for demo
For actual filtering use this kind of measure:
Filter measure = IF([Visit neasure]=[VisitFilter Value],1,0)
Now place it as a filter like this:
After selecting a value the filter displays the correct value:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Hi,
Here is one way to do this:
Data:
Parameter:
VisitFilter = GENERATESERIES(0, 20, 1)
Visit measure =
Visit measure =
Visit neasure = COUNT(Visits[Visit]) //using simple count for demo
For actual filtering use this kind of measure:
For actual filtering use this kind of measure:
Filter measure = IF([Visit neasure]=[VisitFilter Value],1,0)
Now place it as a filter like this:
Now place it as a filter like this:
After selecting a value the filter displays the correct value:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
ValtteriN
Never mind, umm I found my issue while I was replying.Filter = IF([SiteVisit] >= VisitFilter[VisitFilter Value], 1, 0)
Thanks for your help
