Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Is it possible to use GROUPBY with some sort of conditions on the columns? Something along the lines of
I think you'd need to use ADDCOLUMNS ... SUMMARIZE, like
Summary Table =
ADDCOLUMNS (
SUMMARIZE ( 'Employee Detail', 'Employee Detail'[Cost Ctr] ),
"Count of Primary",
CALCULATE (
COUNTROWS ( 'Employee Detail' ),
'Employee Detail'[Employee Category] = "Primary Department"
),
"Count of Residual",
CALCULATE (
COUNTROWS ( 'Employee Detail' ),
'Employee Detail'[Employee Category] = "Residual Employees"
)
)
@Anonymous , I think you can do some calculations using Earlier
Earlier: https://youtu.be/CVW6YwvHHi8
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.