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.
Hi,
How can the below DAX use groupby instead of summarize please?
SUMMARIZE (
'TablePH',
'TableP'[Field1],
'TableP'[Field3],
"CountOfCountries", DISTINCTCOUNT ( 'Table6'[Country] ),
"Hours", [Time]
)
Solved! Go to Solution.
Hi @Anonymous
Please see the below.
Measure = ADDCOLUMNS( GROUPBY( 'TablePH', 'TableP'[Field1], 'TableP'[Field3], "CountOfCountries", COUNTX( CURRENTGROUP(), DISTINCT( 'Table6'[Country] ) ) ), "Hours", [Time] )
Hi @Anonymous
Please see the below.
Measure = ADDCOLUMNS( GROUPBY( 'TablePH', 'TableP'[Field1], 'TableP'[Field3], "CountOfCountries", COUNTX( CURRENTGROUP(), DISTINCT( 'Table6'[Country] ) ) ), "Hours", [Time] )
thank you