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
HI Anonymous
Please try this MEASURE
Could you share your file
Measure = VAR myvalues= CALCULATETABLE ( VALUES ( 'Fact'[Post Code] ), ALLEXCEPT ( 'Fact', 'Fact'[Booking Number] ) ) RETURN CALCULATE ( MAX ( Dim[Miles] ), Filter(all(Dim),Dim[Post Code] in myvalues))Anonymous
or this one
Measure=CALCULATE ( MAX ( Dim[Miles] ), TREATAS(CALCULATETABLE ( VALUES ( 'Fact'[Post Code] ), ALLEXCEPT ( 'Fact', 'Fact'[Booking Number] ) ),Dim[Post Code]))