Grouped distinct count included in measure without making separate grouped table

[Applicable88]

Hello,

I have following count used before:

distictCountValueId = DISTINCTCOUNT('Table1'[ValueID])

Now I just found out that ValueID isn't a distinct key. So I just want to group it additional to one more addtional dimension which is a time "ValueOrderTime", which results in a distinct combination.

I used Qlik before. Something which is like that:

count( distinct ValueID) only needs be wraped in a  grouping function like aggr() to allow me to add one more grouping condition:

count(aggr(count(distinct ValueID), ValueOrderTime))

Is there something equivalent to that in PowerBi without the use of a calculated table?

Thanks in advance.

Best.

[Applicable88]

@amitchandak as always, big thank you!

[amitchandak · Accepted solution]

@Applicable88 , Try a measure like

countrows(summarize(Table, Table[ValueID], Table[ValueOrderTime]))