sumx in visual calcautions

[EduardD]

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.

[v-cgao-msft]

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

[Greg_Deckler · Accepted solution]

@EduardD Here is one way:

Calculation = EXPAND( SUM( [Measure] ), ROWS )