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] )
That was it, and it was so simple, thank you!
Awesome, glad to hear it worked!