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.
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))
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
117 | |
84 | |
49 | |
38 | |
28 |
User | Count |
---|---|
188 | |
76 | |
73 | |
54 | |
42 |