Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MA14
Helper I
Helper I

Table Total On Certain Columns Not Summing up correctly

I have a measure Languages Board = IF([Short Languages]<>0,1,0) on a table visualization but the grand total is not showing correct. I am expecting it to Total it just like the other columns not 1, see screen shot.

Capture.JPG

1 ACCEPTED SOLUTION
v-yetao1-msft
Community Support
Community Support

Hi @MA14 

Mesaure is different from calculated column. When it is added to visual, the fields in Values have no aggregate calculation. So it returns a different value than regular column and calculated column. If you need its last value to be total, I suggest you can create calculated column.

In this case , you can created a calculated column like this :

Column = SWITCH(TRUE(),'Table'[Short Languages]<>0,1,0)

The final result is as shown :

Ailsamsft_0-1652237426175.png

I have attached my pbix file , you can refer to it .

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yetao1-msft
Community Support
Community Support

Hi @MA14 

Mesaure is different from calculated column. When it is added to visual, the fields in Values have no aggregate calculation. So it returns a different value than regular column and calculated column. If you need its last value to be total, I suggest you can create calculated column.

In this case , you can created a calculated column like this :

Column = SWITCH(TRUE(),'Table'[Short Languages]<>0,1,0)

The final result is as shown :

Ailsamsft_0-1652237426175.png

I have attached my pbix file , you can refer to it .

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

VahidDM
Super User
Super User

Hi @MA14 

 

That's a total issue because you used IF statement in your formula, it's very common.

 

Please check this link and you will find how to handle this situation:

 

https://www.vahiddm.com/post/why-my-measure-returns-the-wrong-total

VahidDM_0-1652050879630.png

 

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: 
www.linkedin.com/in/vahid-dm/

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.