Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
GeekAlfPro
Resolver II
Resolver II

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

GeekAlfPro_0-1679906706820.png

 

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 1
GeekAlfPro
Resolver II
Resolver II

to be clearer

i'd like to have something like that

 

GeekAlfPro_0-1679920186111.png


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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors