Measure ignoring Slicer in Hierarchy

[Anonymous]

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?

[v-jialongy-msft · Accepted solution]

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.

[Anonymous]

Hi,

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

Problem Solved!