Forum Discussion
Maximum Mileage
Hi - hope you can help I have two tables. A fact table - Table 1 A dim table - Table 2 They are joined together using the Post Code Column. I'm wanting to create a m...
see a link to pbix file with example. it shows two solutions:
1) calculated column (witn no summarized values option chosen)
2) a measure solution (just drop it to matrix and it should work)
Anonymous
Try this mEasure
Measure =
CALCULATE (
MAX ( Dim[Miles] ),
CROSSFILTER ( Dim[Post Code], 'Fact'[Post Code], BOTH ),
CALCULATETABLE (
VALUES ( 'Fact'[Post Code] ),
ALLEXCEPT ( 'Fact', 'Fact'[Booking Number] )
)
)
Hi Zubair
Many thanks for your speedy response. I have tried the measure and have got the below result:
However this is not quite what I was after. Please could you have another look?
Thank you
Chris