How to resolve summing up after apply of filter.

[Anonymous]

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. 

[Anonymous]

Hi @Anonymous ,

I created some data:

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:

After filtering:

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

[Anonymous]

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