Forum Discussion

A_K's avatar
A_K
Regular Visitor
3 years ago

Removing Filter Context For a Measure

Hello. I have a measure in dax that selects the value of the transaction type, the tranaction name, and the transaction time of a given row from a table visual. The point of this is to determine the number of distinct products that was purchased that has the same transaction type, same transaction name and was purchased within two minutes of each other.

 

The measure goes like this:

var selectTransactionType = SelectedValue(Table[transactionType])

var selectTransactionName = SelectedValue(Table[transactionName])

var selectTime = SelectedValue(Table[time])

 

return

Calculate(DISTINCTCOUNT(Table[product]), ALL(Table),  selectTransactionType = Table[transactionType]), selectTransactionName =  Table[transactionName], ABS(Table[time] - selectTime) <= TIME(0,2,0))

 

This issue with this is that there can be multiple of the same products, with the same transaction type, but a different transaction name and time. I only want to display the maximum value for that paticular product. Right now that measure breaks the calculation down to show me the value of distinct products for that particular transaction name and time. If someone knows a way to just display the maximum value for that particualr product accross all the different transaction name and time that would be great. Thanks

1 Reply