Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • bogomda's avatar
    bogomda
    7 years ago

    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)

     

    https://1drv.ms/u/s!AhUWZ84uo7UAgluNh-SF2xKZltBK

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

 

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

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))
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    Anonymous

     

    or this one

     

    Measure=CALCULATE (
    MAX ( Dim[Miles] ),
TREATAS(CALCULATETABLE (
        VALUES ( 'Fact'[Post Code] ),
        ALLEXCEPT ( 'Fact', 'Fact'[Booking Number] )
    ),Dim[Post Code]))