Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table containing :
VideoID Views DeviceType
1 12 Desktop
1 30 Mobile
1 95 Tablette
...
I want to create a slicer names Views Ranges with ranges like below to filter videos by the sum of their views :
From 100 to 1000
From 1001 to 10000
...
VideoID 1 has a total 137 of views, so when I choose From 100 to 1000 in the filter it will be show.
This is what I tried :
I t
Solved! Go to Solution.
@amirabedhiafi You need to create a new unrelated table, let's call it 'SlicerTable' with a column called 'View Ranges' and a column for Upper limit and Lower limit.
Then create a measure to filter:
FilterRange =
IF( [Total Views] < SELECTEDVALUE(SlicerTable[Upper limit],100) && [Total Views] >= SELECTEDVALUE(SlicerTable[Lower limit], 0) , 1, 0)
Add the [FilterRange] measure as a filter to your visual then filter for [FilterRange] = 1
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@amirabedhiafi You need to create a new unrelated table, let's call it 'SlicerTable' with a column called 'View Ranges' and a column for Upper limit and Lower limit.
Then create a measure to filter:
FilterRange =
IF( [Total Views] < SELECTEDVALUE(SlicerTable[Upper limit],100) && [Total Views] >= SELECTEDVALUE(SlicerTable[Lower limit], 0) , 1, 0)
Add the [FilterRange] measure as a filter to your visual then filter for [FilterRange] = 1
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |