Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Group by 2 values

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi, i solved with the filter.

     

    Wrong data in DB was the problem

     

    Thanks for tips

Mariusz's avatar
Mariusz
Community Champion
7 years ago

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.