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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

what if you try:

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