Forum Discussion
Anonymous
4 years agoNot applicable
Sum Values Based on Multiple Entries from Multiple Columns
Hi, I have a table as shown below: Device ID Day Subtotal Device01 December 1st 10 Device01 December 1st 30 Device01 December 1st 15 Device02 December 1st 10 Device02 ...
- 4 years ago
Anonymous you can use a measure like this
Measure= CALCULATE(SUM(tbl[Subtotal]), ALLEXCEPT(tbl,tbl[Device ID],tbl[Day]))
- 4 years ago
Anonymous when all the axis comes form Scanner Stats
Measure = CALCULATE ( SUM ( ScannerStats[Subtotal] ), ALLEXCEPT ( ScannerStats, ScannerStats[DeviceId], ScannerStats[Date] ) )when axis come from different tables
Measure2 = CALCULATE ( SUM ( ScannerStats[Subtotal] ), VALUES ( ScannerStats[DeviceId] ), VALUES ( DateTable[Date] ) )pbix is attached
smpa01
4 years agoCommunity Champion
Anonymous just to be clear, you want to bring axis from two different tables?
Device Id from ScannerStats and Date from DateTable?
Anonymous
4 years agoNot applicable
Yes that is correct.
I do have a date field in ScannerStats as well which didn't seem to work with your provided solution, but if it works for you I wouldn't mind using it