Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I have a filtered table where the total of a column is supposed to equal the filtered total, but the total represents the unfiltered total. I haven't created any measures or calculated columns/fields, just simply selecting to sum the value as shown in the second picture below. How do I get the column total to sum only the filtered amounts?
this is the table
filter with sum for the column
Hi @melanieotto ,
Is the column "Outstanding Balance" written by DAX? You could share a sample file link from where I can download it.
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 84 | |
| 49 | |
| 36 | |
| 31 | |
| 30 |