Forum Discussion
GeekAlfPro
3 years agoHelper V
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
- GeekAlfProHelper V
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