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)
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]))