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 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's avatar
    Anonymous
    7 years ago

    Hi, i solved with the filter.

     

    Wrong data in DB was the problem

     

    Thanks for tips

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    what if you try:

    Measure = 
    SUMX(
    ADDCOLUMNS(
        SUMMARIZE( Table2, Table2[Date]),
        "Count",
        CALCULATE( DISTINCTCOUNT(Table2[Date]))),
        [Count]
    )
  • Mariusz's avatar
    Mariusz
    Community Champion

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, i solved with the filter.

     

    Wrong data in DB was the problem

     

    Thanks for tips