Show row and column total value across all cells in matrix visual

[souvik900766]

Hi !

I want to calculate a measure where I want to fix the base across rows and columns in matrix visual in power.
For this I have used :- 

CALCULATE([Increment],ALL('Category Name),ALL(Country Name))
Refer the result in this image:-

Kindly help me out.
Little urgent.
Thanks in advance !

[Jihwan_Kim · Accepted solution]

Hi, @souvik900766 

I am not sure how your data model looks like, but it seems the country name column is coming from a different table.

Please try to write something like below.

Increment Total = CALCULATE([Increment measure], ALL(your main fact table))

Or, please share your sample pbix file's link here, then I can try to come up with a more accurate measure.

Thanks.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM