Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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))
)
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.