Forum Discussion

Fidzi8's avatar
Fidzi8
Icon for Helper V rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper V rankHelper 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
    Icon for Super User rankSuper User
    6 years ago

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

    • Fidzi8's avatar
      Fidzi8
      Icon for Helper V rankHelper V
      6 years ago

      amitchandak 

      but column maxx is same as column KM, what should I do next?


      I donť know how I have to write formula

      Thank you, Ondřej

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        6 years ago

        Fidzi8 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.