The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Lets say i have sales amount by year and month. I can slice and dice the sales by few dimensions, branch, agent, channel.
I also have target amount by year and month. But i only have target by branch and not other dimension.
In my dashboard, i have the dimensions are slicers (branch, agent,channel). In a chart i showed sales amount and target as well.
If user click on branch slicers, i can have the amount correctly. But when i click on other slicer such as agent, target shows the total. Is there any way i can create a measure such that target is not calculated when other slicers are filtered(in this case agent and channel slicers)? If yes any idea how to write such code?
Solved! Go to Solution.
use isfiltered
refer : https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
use isfiltered
refer : https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin