Group by 2 values

[Anonymous]

Hi, 

how can i transalte this sql query in dax measure?

Select COUNT(ITEMID) AS ITEMID
from AXDBBI.dbo.MDC_INVENTQUALITYORDERTABLE
group by Itemid,Data_Ricevimento

I need to count the sum of ITEMID group by DATA

Example:

173365    2019-06-20

154344    2019-06-20                                       (Result = 1)

213432    2019-01-20

213123    2019-01-20                                       (Result = 1)

Total result is 2. I want that in a dax measure.

I tried to do count(itemid);filter(table;data)   but it didn't work

Help pls

[Anonymous · Accepted solution]

Hi, i solved with the filter.

Wrong data in DB was the problem

Thanks for tips

[Anonymous]

what if you try:

Measure = 
SUMX(
ADDCOLUMNS(
    SUMMARIZE( Table2, Table2[Date]),
    "Count",
    CALCULATE( DISTINCTCOUNT(Table2[Date]))),
    [Count]
)

[Mariusz]

Hi @Anonymous 

Have you tried DISTINCTCOUNT?

Measure = DISTINCTCOUNT( YourTable[Date] )

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.