Forum Discussion
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
- Anonymous7 years ago
Hi, i solved with the filter.
Wrong data in DB was the problem
Thanks for tips
3 Replies
- AnonymousNot applicable
what if you try:
Measure = SUMX( ADDCOLUMNS( SUMMARIZE( Table2, Table2[Date]), "Count", CALCULATE( DISTINCTCOUNT(Table2[Date]))), [Count] ) - MariuszCommunity 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. - AnonymousNot applicable
Hi, i solved with the filter.
Wrong data in DB was the problem
Thanks for tips