Forum Discussion
DAX Help - complex calculation
Hello, I am encountering a roadblock in the DAX code I am trying to develop and would appreciate any guidance or support! Here is a picture of the work in progress (see below). The first lev...
I think you could create a measure like
Total Units Sold =
SUMX (
KEEPFILTERS ( SUMMARIZE ( Transactions, Item[Item Key] ) ),
CALCULATE ( COUNTROWS ( Transactions ) )
)
This assumes that the item in your matrix is coming from the Items table.