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.
Hi,
I want to use a filter some way to allow users to select the value for N and filter the measure accordingly:
caculate(count(users),date<=today()-N)
where i want N to be a parameter that can be supplied by user.
If ,the KPI is count of users who accessed system in Last N days,its simple,i use relative slicer and change the N and measure gets filtered accorndingly.Since,it is the negation,i need think i cant say filter/slicer and then do the opposite calculation in the measure.
If it is not possible,am i left with the only way to create measures for each requirement; one for last 7 days,one for last 30 days and so on
Solved! Go to Solution.
To let people select a value of N, create a disconnected parameter table that will store all the values of N you're interested in. This table will be used as a slicer. Then create this measure:
[# Users] = var __today = TODAY() var __dayOffset = SELECTEDVALUE( ParameterTable[DayOffset] ) var __endDate = __today - __dayOffset var __numOfUsers = CALCULATE( COUNTROWS( Users ) DateTable[Date] <= __endDate ) return __numOfUsers
If nothing is selected from ParameterTable, __endDate will be equal to TODAY(). For the above to work, you have to have a DateTable that is a proper Date table in the model.
Best
Darek
To let people select a value of N, create a disconnected parameter table that will store all the values of N you're interested in. This table will be used as a slicer. Then create this measure:
[# Users] = var __today = TODAY() var __dayOffset = SELECTEDVALUE( ParameterTable[DayOffset] ) var __endDate = __today - __dayOffset var __numOfUsers = CALCULATE( COUNTROWS( Users ) DateTable[Date] <= __endDate ) return __numOfUsers
If nothing is selected from ParameterTable, __endDate will be equal to TODAY(). For the above to work, you have to have a DateTable that is a proper Date table in the model.
Best
Darek
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 |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
73 | |
50 | |
45 | |
20 | |
17 |