Forum Discussion

Fidzi8's avatar
Fidzi8
Helper V
6 years ago
Solved

Wrong value in Matrix

Hi,  Please, I need advice. My matrix works badly and I donť know how edit DAX   My data tabel is here:   Thank you  Ondřej
Tips and Tricks
  • Fidzi8's avatar
    Fidzi8
    6 years ago

    Hi,

    this is the solution.

    1. Max km = MAX('Profitabilita own fleet AGG'[KM])
     
    2. sum max = SUMX(SUMMARIZE(VALUES('Profitabilita own fleet AGG'[KM]);'Profitabilita own fleet AGG'[KM];"ABCD";'Profitabilita own fleet AGG'[Max km]);[ABCD])
     
    Ondrej
amitchandak's avatar
amitchandak
Super User
6 years ago

Fidzi8 , It should be like

divide(Sum[Table[KC]),Sum(Table[KM])), replace with the correct columns

Fidzi8's avatar
Fidzi8
Helper V
6 years ago

Hi amitchandak ,

It is the same 😕

Thank you 
Ondřej

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Fidzi8 , I am not able see the level name in you table. but seem like you need sum till a level then take max of Avg for KM.

     

    Try like

    maxx(values(Table[level3]),sum(Table[KM]))

     

    Where Level3 is name level having that 1481 value

    • Fidzi8's avatar
      Fidzi8
      Helper V
      6 years ago

      amitchandak ,

      I don´t know how I have to use this formula, is this correct?

      Thank you

      Ondřej

      • amitchandak's avatar
        amitchandak
        Super User
        6 years ago

        Fidzi8 , yes, not sure what the name of the column so used that