Measure ignoring Slicer in Hierarchy

Anonymous — Thu, 16 May 2024 14:10:03 GMT

Hi,

I have created this kind of measure:

% of value assigned to Director =

CALCULATE(DIVIDE(

CALCULATE(SUMX(Table,Table[Value]),

ALLEXCEPT(Table,

Table[vendor], Table[Director])),

CALCULATE(

SUMX(Table,Table[Value]),

ALLEXCEPT(Table,Table[vendor]))), ALL(Table[Project Leader]))

Basically the concept is that I have a table with columns "Vendor", "% of value delivered by vendor in total", "Director", "% of value assigned to Director", "Project leader", "% of value assigned to Project Leader". One vendor can deliver to many directors so this is the highest hierarchy spot. Then one director controll several Project Leader. I want this measure to show % of value assigned to director but only for this Vendor and is calculating correctly.

My problem is that when I put in the slicer with Project Leaders and choosing one of them, then the value of the measure described earlier is always 100%. Which is logical, because one project leader belongs to only one director, but I want this slicer to filter only rows with Project Leader, not the measure. Is there any way to do that?

Re: Measure ignoring Slicer in Hierarchy

Anonymous — Fri, 17 May 2024 01:10:53 GMT

Hi Anonymous

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

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

Re: Measure ignoring Slicer in Hierarchy

Anonymous — Fri, 17 May 2024 06:21:17 GMT

Hi,

I figured it out, the problem was the filter on visual that has been used.

Problem Solved!

topic Re: Measure ignoring Slicer in Hierarchy in DAX Commands and Tips

Measure ignoring Slicer in Hierarchy

Re: Measure ignoring Slicer in Hierarchy

Re: Measure ignoring Slicer in Hierarchy