Forum Discussion
Problem with Total column in visual matrix
- Anonymous2 years ago
Hi rcardenasbc ,
Based on the description, try to add the following DAX formula.
VAR Result = IF( ISBLANK(Valor), 0, Valor ) VAR TotalResult = IF( HASONEVALUE('DAX Calendar'[MesNumero]), Result, SUMX( VALUES('DAX Calendar'[MesNumero]), Result ) ) RETURN TotalResulViewing the following document to learn more information.
HASONEVALUE function (DAX) - DAX | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rcardenasbc 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