Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
i've a dataset with an id and a family.
i want to calculate the kms average by id so far so good
My issue is when i want to display in front of each id, the family average like below.
i don't find the dax code to stay at the family level
Solved! Go to Solution.
Thanks @Arul
I finally managed to display what i want
it was the wrong columns i assume...
i now display the column of the calculate table, with the column of the vehicle just be
For those who are inserested, if you want to display the value in a card you muste create a measure :
kms quotidien moyen famille =
LOOKUPVALUE('Données par Famille'[Kms / jour], 'Données par Famille'[Famille], SELECTEDVALUE('Paramètres Véhicules'[Famille]))
Here is the data model
in 1 you can see the links between the id and the family.
in 2 i tried to sumarize the date by family in a separated table. i also tried a lookupvalue, but without success.
What are all the columns that you are using in your visual?
Thanks,
Arul
i use
'Paramètres Véhicules'[Famille], 'Paramètres Véhicules'[N° Parc] and the measure
kms quotidien moyen famille =
CALCULATE(
AVERAGE('daily_aggregate_final'[max_distance])
,ALLEXCEPT('Paramètres Véhicules', 'Données par Famille'[Famille])
)
Am asking the columns and measures used in the visual.
Thanks,
Arul
Thanks @Arul
I finally managed to display what i want
it was the wrong columns i assume...
i now display the column of the calculate table, with the column of the vehicle just be
For those who are inserested, if you want to display the value in a card you muste create a measure :
kms quotidien moyen famille =
LOOKUPVALUE('Données par Famille'[Kms / jour], 'Données par Famille'[Famille], SELECTEDVALUE('Paramètres Véhicules'[Famille]))
i'm not sure that i well understood the question, but here is a screenshot of my visual :
Hello, see the formulas below and the outcomes in the image:
KMS Avg:=AVERAGE([Kms Average])
KMS Family Avg.:=CALCULATE([KMS Avg],FILTER(ALLSELECTED('Table1'[Famille]),'Table1'[Famille]=MAX(Table1[Famille])))
KMS Family Avg v2.:=CALCULATE([KMS Avg],ALLEXCEPT('Table1','Table1'[Famille]))
, but the formula you want is the v2:
KMS Family Avg v2.:=CALCULATE([KMS Avg],ALLEXCEPT('Table1','Table1'[Famille]))
Hello @BrianConnelly ,
Thanks for your answer, unfortunately, when i display the measure in a table, the average is recalculed by id
Are the ID column and Famille column comes from different table? If yes, do they have reltionship and what is it?
Thanks,
Arul
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |