Help required please

[tsmehta]

In my direct query dashboard I have defined 2 measures

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

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

TotManpowerAllSites = ManpowerSiteABC+ManpowerSiteXYZ

The value of above measure remains in the same irrespective of various other slicers applied. How can I get value of ManpowerSiteABC & ManpowerSiteXYZ based on slicers selected. Stuck up for long on this, please help.

[uzuntasgokberk · Accepted solution]

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 |

[Anonymous · Accepted solution]

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.

[uzuntasgokberk · Accepted solution]

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 |