Forum Discussion

Xaraja's avatar
Xaraja
Helper III
4 years ago

Measure with Filter

I feel like this should be obvious but I am not finding anything on Google that seems relevant so maybe I'm missing something. I am working with an existing dataset that was working but now isn't so ...
Help with DAX Measure
Xaraja's avatar
Xaraja
Helper III
4 years ago

I get an error with that that says "A single value for column 'item_qty' in table 'Transactions' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Xaraja ,

 

Maybe you can try this code, use max to get the value of current item:

Before Dollar Value = 
CALCULATE ( 
    max(Transactions[item_qty]) * max(Transactions[Products.Price Multiplier]) * max(Warehouse[Average]),
Transaction[System Cycle] = "System Cycle Count"
)

 

Best Regards

Community Support Team _ chenwu zhu

 

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