Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
This was created for me using daxstudio. How should I revise it for Power BI to evaluate all ID's, not just on the one filtered?
/--Filter Report Date to start after 5/1/2023 & only Clicked
//EVALUATE
//FILTER(
// 'Table',
// 'Table'[Report Date] >= 5/1/2023 &&
// 'Table'[Click] = "True"
// )
//
--Calculate Cumulative Sum of Primary, per User & Report Date
EVALUATE
VAR currentdate = MAX('Table'[Report Date])
RETURN
SUMMARIZECOLUMNS(
'Table'[Report Date],
'Table'[Formatted Count],
FILTER('Table','Table'[Employee ID] = "68712"),
"ClickCount", SUMX(
FILTER(
'Table',
'Table'[Report Date] <= currentdate
),
CALCULATE( COUNTA('Table'[Employee ID))
)
)
Thanks in advance.
~User 900
Solved! Go to Solution.
@user900 , a new table
Table=
VAR currentdate = MAX('Table'[Report Date])
RETURN
SUMMARIZECOLUMNS(
'Table'[Report Date],
'Table'[Formatted Count],
FILTER('Table','Table'[Employee ID] = "68712"),
"ClickCount", SUMX(
FILTER(
'Table',
'Table'[Report Date] <= currentdate
),
CALCULATE( COUNTA('Table'[Employee ID))
)
)
or create a measure and use the required columns in the table visual
SUMX(
FILTER(
'Table',
'Table'[Report Date] <= currentdate && 'Table'[Employee ID] = "68712"
),
CALCULATE( COUNTA('Table'[Employee ID))
)
@user900 , a new table
Table=
VAR currentdate = MAX('Table'[Report Date])
RETURN
SUMMARIZECOLUMNS(
'Table'[Report Date],
'Table'[Formatted Count],
FILTER('Table','Table'[Employee ID] = "68712"),
"ClickCount", SUMX(
FILTER(
'Table',
'Table'[Report Date] <= currentdate
),
CALCULATE( COUNTA('Table'[Employee ID))
)
)
or create a measure and use the required columns in the table visual
SUMX(
FILTER(
'Table',
'Table'[Report Date] <= currentdate && 'Table'[Employee ID] = "68712"
),
CALCULATE( COUNTA('Table'[Employee ID))
)
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 51 | |
| 40 | |
| 37 | |
| 14 | |
| 14 |
| User | Count |
|---|---|
| 85 | |
| 69 | |
| 38 | |
| 29 | |
| 27 |