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 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Fidzi8's avatar
Fidzi8
Icon for Helper V rankHelper 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 

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

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