Forum Discussion

bajimmy1983's avatar
bajimmy1983
Advocate V
9 years ago

Percentage Sharing by level

Hi Community.    Could anyone help me to resolve this little problem with a specific measure? You can replicate What I have according to Sample File.   What I need is to set up a PivotTable with ...
Need Help
Sean's avatar
Sean
Community Champion
9 years ago
Shr Bill NEW =
IF (
    ISFILTERED ( Client[CLIENT] ),
    DIVIDE (
        [Act Bil BRL],
        CALCULATE ( [Act Bil BRL], ALLSELECTED ( Client[CLIENT] ) ),
        0
    ),
    IF (
        ISFILTERED ( 'date'[MONTH] ),
        DIVIDE (
            [Act Bil BRL],
            CALCULATE ( [Act Bil BRL], ALLSELECTED ( 'date'[MONTH] ) ),
            0
        ),
        DIVIDE (
            [Act Bil BRL],
            CALCULATE ( [Act Bil BRL], ALLSELECTED ( PurePlayers[PURE PLAYER] ) ),
            0
        )
    )
)

EDIT: In case anyone is wondering why there are 3 Shr Bil Measures?

Its because the Shr Bil in the file was different that the one listed above in the original question which I named Shr Bil WEB.

bajimmy1983's avatar
bajimmy1983
Advocate V
9 years ago

Sean thanks for your reply.

 

I could realize that your NEW measure is almost the same as mine, excluding last part of my measure (thanks again). That's ok. 

 

Now try to picture in a Measure as follow below:

 

First Scenario (Already working)

First Scenario (Already working ina PivotTable)

Now, imagine I want to change some information (between levels), but have the same result in % with a different perspective:

 

Important: Note that I have removed field "GRUPO" from Row context and put it in a Slicer. Then I want to filter just one "GRUPO", in this case "HMG". When I do this, I get a wrong % in the first level: 

 

Second Scenario (NOT WORKING as spected)

This measure should be flexible to understand it and then bring back the correct % in all levels again like below:

 

Second Scenario (EXPECTED) = Flexible Measure

 

Thanks again,

 

  • bajimmy1983's avatar
    bajimmy1983
    Advocate V
    9 years ago

    Sean, Good morning. Do you know something else I could do to resolve this? 

     

    Thanks a lot and have a nice day.

    • bajimmy1983's avatar
      bajimmy1983
      Advocate V
      9 years ago

      @MattAllington. I know you are a super super super user and expert. If you have time, could you please try to help?

       

      Thanks and best regards,