Help required please

Hello tsmehta ,

Could you please change the measure and try again please?

ManpowerSiteABC=calculate(SUM(view1[avg_days]), FILTER(view,view1[site]="ABC"))

ManpowerSiteXYZ=calculate(SUM(view1[avg_days]), FILTER(view,view1[site]="XYZ"))

TotManpowerAllSites = ManpowerSiteABC+ManpowerSiteXYZ

İf that will no work. Could you please share dummy pbi fle based on your case.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

Thanks for the reply from uzuntasgokberk, please allow me to provide another insight.
Hi tsmehta ,

If the slicer is using the "site" column of the "view1" table, then the filter parameter inside the measure will override the external filter for the same column, resulting in no change to the measure.

In my testing, creating a slicer using other columns of the "view1" table and applying it can make the measure change.
You can try this.

Best Regards,
Dengliang Li

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