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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply

Table Filtered but want a column to ignore table filter and give summed value for all

Hi there

 

I have a table returning customer numbers, with payments values in a column. The table is filtered to the relative week, so value for that week showing in the column called Relative Week = 0. What I also want is to add a column that gives the overall total,all weeks summed for that customer against every week in the dataset. So for example

TenantRelative  week = 0All weeks Summed Up
125500
210200
31560
41001000

 

I just cant get my DAX to work. 

I'd be very grateful if somoene could help please

 

Many thanks

Karen

1 ACCEPTED SOLUTION

I have sorted it by using IGNOREFILTERS 🙂

 

CALCULATE(SUM(Value]),REMOVEFILTERS(table[relative_week]))

View solution in original post

1 REPLY 1

I have sorted it by using IGNOREFILTERS 🙂

 

CALCULATE(SUM(Value]),REMOVEFILTERS(table[relative_week]))

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.