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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Kiranbc
Helper I
Helper I

How to resolve summing up after apply of filter.

 

Hi All,

In the below you can see different baseline hours for different clients (Image 1). When I select the particular client (PLC) from the filter the baseline hours are summing up (1332) which is wrong and it should be 887.11. Any work around for this? 

 

Note that Billable hours and baseline hours dax measures. I tried calculated columns but there are over 4500 employees it takes huge space. 

 

Kiranbc_1-1671114122559.png

Kiranbc_3-1671114448929.png

 

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi @Kiranbc ,

I created some data:

vyangliumsft_0-1671159735330.png

You need to add Allselectd() to Measure.

Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.

ALLSELECTED function (DAX) - DAX | Microsoft Learn

Here are the steps you can follow:

1. Create measure.

Measure =
SUMX(ALLSELECTED('Table'),[Value])

2. Result:

Unfiltered:

vyangliumsft_1-1671159735332.png

After filtering:

vyangliumsft_2-1671159735333.png

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Thank you for answering, but my requirement is below. I have below data. The below data is correct when i dont filter particular client (2nd column), but when i filter the 2nd row client, the fifth column Clientbase sums up values (2nd screen shot). Let me know how to avoid this. 

 

I filtered on 2nd row it should show clientbase hours as 471.04 but 

Kiranbc_0-1671603599779.png

 

Kiranbc_1-1671603734390.png

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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