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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Bambang_Sono
Frequent Visitor

Total on the visual table

hi please ask I want to sum in the table automatically in the target column. and in this picture I share there are two data values that I took from the release data table.

 

help7.png

2 REPLIES 2
Anonymous
Not applicable

Hi @Bambang_Sono ,

The totals row removes all filters and calculates based on the calculation method used in your DAX. You can use the 'selectedvalue' function.Need more info, like what DAX are you using? A modification with the IF function should meet your needs.

 

Best Regards

ryan_mayu
Super User
Super User

@Bambang_Sono 

you can try 

= sumx(values(Day), target)





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.