Forum Discussion

KleinhansStefan's avatar
KleinhansStefan
Frequent Visitor
2 years ago
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...
DAX
Relational Table
Slicer
  • ValtteriN's avatar
    ValtteriN
    2 years ago

    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/

KleinhansStefan's avatar
KleinhansStefan
Frequent Visitor
2 years ago

ValtteriN 
Thank you for this. I eventually got it to work, had some trouble getting to where you where.
So the concept works, I was just wondering is there was no way to show customer greater than selected value?