Forum Discussion

GeekAlfPro's avatar
GeekAlfPro
Helper V
3 years ago

Family vehicule average

Hello,

 

i mess with a family product average

i want to compare the kms value of a specific vehicle with his family average.

i have a calculated table

 

Données par Famille = SUMMARIZE(
    'Paramètres Véhicules'
    ,'Paramètres Véhicules'[Famille]
    ,"Kms / jour"
    , AVERAGEX('daily_aggregate_final', 'daily_aggregate_final'[max_distance])
    ,"Kwh"
    //, AVERAGEX('daily_aggregate_final', DIVIDE(SUM('daily_aggregate_final'[kwh_consumption]),[Somme Kms Electric Final]))
    , DIVIDE(SUM('daily_aggregate_final'[kwh_consumption]),[Somme Kms Electric Final]
    ))

 

 

And a link in my model

 

But when i want to display the value of a specific family, in a card for example, this is the average of the five families that is returned.

 

Can someone explain me how to have only the value of the vehicle family?

 

 

1 Reply

  • to be clearer

    i'd like to have something like that

     


    I think, it's not the good forum, but i don't see how to move the topic