Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 calculated column to calculate the site visits based on the Arrival time.
Then I created a new table with a calculated value for the numbers
" CountFilter = GENERATESERIES(1, 20, 1)"
Now I cant get it to filter
I have tried to create a relationship between the two by and it went for Many-to-One (MainTable - to - CountFilter)
When I leave it on single then I only get a 1 or 0 value, if I leave it on Both direction then i get all the values from 1 to 20 but it shows no data when I select anything other than 1
Visual is a simple table with customer and the Sum of Site visits
the DAX calculate column code is
PS.
I tried this below as well, did not work.
Filtered Visits =
VAR SelectedCount = SELECTEDVALUE(CountFilter[Value])
RETURN
CALCULATE(
COUNTROWS(FILTER('MainTable', NOT(ISBLANK('MainTable'[ArrivalTime].[Date])))),
FILTER(CountFilter, CountFilter[Value] <= SelectedCount)
)
Solved! Go to Solution.
Hi,
Here is one way to do this:
Data:
Parameter:
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/
Proud to be a Super User!
@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?
Hi,
Here is one way to do this:
Data:
Parameter:
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/
Proud to be a Super User!
@ValtteriN
Never mind, umm I found my issue while I was replying.
User | Count |
---|---|
20 | |
14 | |
11 | |
8 | |
6 |
User | Count |
---|---|
23 | |
23 | |
20 | |
15 | |
10 |