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
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
6 years ago

Fidzi8 

 

Just use MAX instead of SUM.

Measure =
MAX ( 'Profitabilita own fleet AGG'[KM] )

Measure 2 =
DIVIDE ( SUM ( 'Profitabilita own fleet AGG'[KC] ), [Measure] )

 

  • Fidzi8's avatar
    Fidzi8
    Helper V
    6 years ago

    Hi v-chuncz-msft, amitchandak 

    I have still problem with calculation Kč/km.
    When I calculate Max km and this value used to divide Kč/Max km than result is wrong.

    thank you
    Ondřej

    • Fidzi8's avatar
      Fidzi8
      Helper V
      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