Forum Discussion
Solved
Getting a table total into a measure
I have a Power BI report that has some complicated measures, most of which I've figured out. One that I can't seem to get is a measure that shows the number of transactions for those sales within a s...
After reviewing the screenshot again, it looks like we first need to aggregate the sales by SellToNo. The previous measure was aggreageting by the Invoice. Please try this one instead:
Transaction Count > $100,000 = SUMX( FILTER( VALUES(Fact_Invoice[SellToNo]), CALCULATE(SUM(Fact_Invoice[NetSales])) > 100000 ), [TY Invoice Count] )
It's still blank.
After reviewing the screenshot again, it looks like we first need to aggregate the sales by SellToNo. The previous measure was aggreageting by the Invoice. Please try this one instead:
Transaction Count > $100,000 =
SUMX(
FILTER(
VALUES(Fact_Invoice[SellToNo]),
CALCULATE(SUM(Fact_Invoice[NetSales])) > 100000
),
[TY Invoice Count]
)
That was it, and it was so simple, thank you!
Awesome, glad to hear it worked!