Forum Discussion

EduardD's avatar
EduardD
Icon for Advocate III rankAdvocate III
1 year ago
Solved

sumx 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 ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    1 year ago

    EduardD Here is one way:

    Calculation = EXPAND( SUM( [Measure] ), ROWS )
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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