topic % of total Measure no sum Up Correct in DAX Commands and Tips

% of total Measure no sum Up Correct

Anonymous — Thu, 12 Oct 2023 17:11:45 GMT

i Have a measure wich the % total are not sum but instead are geting the total and apply the result in the total row i the values, im making a simple calculation of number over total, how i can solve this issue without change my meassure
this is my meassure :

Within following 3 months = VAR T3id = CALCULATE(MIN('Sales'[OrderDate]), VALUES(Sales[CustomerKey]))

VAR t2id = EOMONTH(T3id, 3)

VAR t1id = EOMONTH(T3id, 1)

VAR T0id = DATE(YEAR(t1id), MONTH(t1id), 1)

RETURN

CALCULATE(

[Customers],

Sales[OrderDate] <= t2id && Sales[OrderDate] >= T0id

)
and the % calculation is :

% First Following 3 Months = [Within following 3 months] / [Customers]

My Table

Re: % of total Measure no sum Up Correct

Greg_Deckler — Thu, 12 Oct 2023 17:56:41 GMT

Anonymous 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

Re: % of total Measure no sum Up Correct

Anonymous — Mon, 16 Oct 2023 08:32:49 GMT

Hi Anonymous ,

Please try to create a new measure.

New measure=SUMX(VALUES(Sales[OrderDate]),[your measure])

Places the new measure value on the visual object.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

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.