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 have created a measure, the results are good for rows but incorrect for the total :
Cumul Effectuées (h) =
VAR MaxDate = MAX(Calendrier[Date])
RETURN
CALCULATE(
[Total H R]
,FILTER ( ALL (Calendrier) , Calendrier[Date] <= MaxDate ) )
Could you please help me to resolve this please ?
Kind regards,
Mohammad
Solved! Go to Solution.
Please use this expression instead, replacing Table[Column] with the one you use on the rows of your matrix. It should give you the correct results for each row and the total.
NewMeasure = SUMX(VALUES(Table[Column]), [Cumul Effectuees (h)])
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Please use this expression instead, replacing Table[Column] with the one you use on the rows of your matrix. It should give you the correct results for each row and the total.
NewMeasure = SUMX(VALUES(Table[Column]), [Cumul Effectuees (h)])
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |