Forum Discussion
EduardD
Advocate III
Advocate IIIsumx in visual calcautions
The quesion is about Visaul Calculations (preview) in Power BI:
Formula: ColumnCount = SUMX(VALUES([Product]), 1) and Formula: ColumnCount = Calculate(SUMX(VALUES([Product]), 1))
return 1 for the Total row of ColumnCount instead of number of unique records for Product.
Any other ways to get Total caclulation right using visual calculations?
Thank you.
PS: Greg_Deckler if you might know, it is related to measure total.
EduardD Here is one way:
Calculation = EXPAND( SUM( [Measure] ), ROWS )
2 Replies
- Greg_Deckler
Community Champion
EduardD Here is one way:
Calculation = EXPAND( SUM( [Measure] ), ROWS ) Hi EduardD ,
May I ask if Greg's reply was helpful? If so, please mark it as a solution so it can be helpful to others.
If the question is still open, please provide more details below so we can better assist you.Best Regards,
Gao
Community Support Team
