Forum Discussion
Solved
Multiple columns join/goup
Hi I'm new to PowerBI, though I have developer background. I'm stuck now on a report that has 2 columns: one with vehicles count by type, location and month and another with days in service of ve...
Hi trailmax,
Please try this measure:
sum measure = CALCULATE ( SUM ( Service[ServiceLength] ), FILTER ( ALLSELECTED ( Service ), Service[Date] = SELECTEDVALUE ( FleetCount[Date] ) && Service[Location] = SELECTEDVALUE ( FleetCount[Location] ) && Service[Type] = SELECTEDVALUE ( FleetCount[Type] ) ) )Best regards,
Yuliana Gu
https://www.dropbox.com/s/pxfgq3c7bkmj6c6/Sample.pbix?dl=0
I created a group by and sum by service length table in the file in there, also i created a reference table and hopefully that should help you achieve your solution.
nirvana_moksh, Anonymous I've tried doing the intermediate tables, the problem that I need 3 of them and they are not disjointed - I need Location, Date, Type. Like this:
And when it comes to filters, all three need to work like one table, not 3 disjointed.
I'll keep this technique in mind for the future - thank you for looking into this!
