Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I try to have a new measure for make a sum for a measure :
Hi @Vanessa250919 ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Vanessa250919, here is my suggested solution.
You want the measure [Nbre_postes_pourvoir] to be calculated for each Nom_enterprise, and then summed up to get the total. To achieve this, your measure needs to group the data up by Nom_enterprise, calculate the Nbre_postes_pourvoir, and then sum up the results. The SUMX function allows you to do this.
Please try changing the DAX for [Nbre_postes_pourvoir] to this:
Nbre_postes_pourvoir =
SUMX(
VALUES(T_Convention[Nom_enterprise]),
CALCULATE(SUM(T_Convention[DE_A_Engager]))
/
DISTINCTCOUNT(T_Convention[Key_Suivi])
)
Is this what you are looking for?
User | Count |
---|---|
56 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
17 |