Forum Discussion

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

Helper V

6 years ago

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

Thank you

Ondřej

Super User

6 years ago

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

Fidzi8
Helper 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
  Super User
  6 years ago
  Fidzi8 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
  - Fidzi8
    Helper V
    6 years ago
    amitchandak,
    I can share pbix but I don't know how share.
    I don't see share button.
    
    Thank you,Ondřej