Getting unique number for Item ID for a measure

[Jorjor]

Hi,

I'm having an issue getting the QTY for each unique ID combo using a meassure. Is there any help?

Current Code:

QTY_ = SUMX(FILTER(table1(ID1)=MAX([ID1]) && Table 1(ID2)=MAX([ID2])),[QTY_])

[Anonymous · Accepted solution]

Hi, @Jorjor 

You can try the following DAX expression:

QTY_Combined = 
SUMX(
    SUMMARIZE(
        'Table', 
        'Table'[ID1], 
        'Table'[ID2], 
        "TotalQty", SUM('Table'[QTY])
    ), 
    [TotalQty]
)

Then put it in view, here is my preview:

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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