topic Re: summarize to groupby in DAX Commands and Tips

summarize to groupby

Anonymous — Fri, 20 Sep 2019 16:03:55 GMT

Hi,
How can the below DAX use groupby instead of summarize please?

SUMMARIZE (
'TablePH',
'TableP'[Field1],
'TableP'[Field3],
"CountOfCountries", DISTINCTCOUNT ( 'Table6'[Country] ),
"Hours", [Time]
)

Re: summarize to groupby

Mariusz — Mon, 23 Sep 2019 09:15:19 GMT

Hi Anonymous

Please see the below.

Measure = 
ADDCOLUMNS( 
    GROUPBY(
        'TablePH',
        'TableP'[Field1],
        'TableP'[Field3],
        "CountOfCountries", COUNTX( CURRENTGROUP(), DISTINCT( 'Table6'[Country] ) )
    ),
    "Hours", [Time]
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

Re: summarize to groupby

Anonymous — Mon, 23 Sep 2019 09:19:11 GMT

thank you

Re: summarize to groupby

Mariusz — Mon, 23 Sep 2019 11:01:02 GMT

Hi Anonymous

No problem, happy to help!

Best Regards,
Mariusz

Please feel free to connect with me.