Wrong value in Matrix

[Fidzi8]

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

[Fidzi8]

@amitchandak,
I hope that pbix will open. 

https://drive.google.com/file/d/1VhR7oDN4ksv_cxgcrXkgJtj06n1GpKOt/view?usp=sharing 

Thank you,
Ondřej

[v-chuncz-msft]

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

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 · Accepted solution]

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]

@Fidzi8 , It should be like

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

[Fidzi8]

Hi @amitchandak ,

It is the same 😕

Thank you 
Ondřej

[amitchandak]

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

@amitchandak ,

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

Thank you

Ondřej

[amitchandak]

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

[Fidzi8]

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

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

[Fidzi8]

@amitchandak,

I can share pbix but I don't know how share.

I don't see share button.

Thank you,Ondřej 

[amitchandak]

@Fidzi8 , you can upload to drop box or onedrive and share link