Forum Discussion
Help required please
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.
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.
2 Replies
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.