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 please prepare a sample pbix, upload in g/1 drive and please share the link
Anonymous
4 years agoNot applicable
Sample pbix here:
https://drive.google.com/file/d/1avV3T8nW6Maluxg3Piu3f6TJ5IS6WrWt/view?usp=sharing
Thank you.
- smpa014 years agoCommunity Champion
Access denied
- Anonymous4 years agoNot applicable
Apologies, link here with access:
https://drive.google.com/file/d/1avV3T8nW6Maluxg3Piu3f6TJ5IS6WrWt/view?usp=sharing
- smpa014 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?