Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
@avivbnbn
You can use create another measure and follow this pattern:
NewPercentageresponded =
if(Hasonevalue(Date[Year]), [Percentage respond], Averagex(Values(Date[Year]), [Percentage respond]))
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
thank you! can you explain me the logic behind the formula?
@avivbnbn To add to @tharunkumarRTK's information, First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
@avivbnbn
You can use create another measure and follow this pattern:
NewPercentageresponded =
if(Hasonevalue(Date[Year]), [Percentage respond], Averagex(Values(Date[Year]), [Percentage respond]))
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
but now i have more columns.
i want the same result as i posted but different total
You can remove your actual measure from the visual now.
or if you dont want to remove it then modify your actual measure by following the logic I shared
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |