Forum Discussion

DonapatiSP_3105's avatar
DonapatiSP_3105
New Member
5 years ago
Solved

Total Label Value into variable - Stacked bar chart

In a stacked bar chart, i want to show percentage of each stack in a bar. I have tried using below. This worked well for many other reports. In a particular report, i get only 100%. I have tried all ...
Need Help
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi DonapatiSP_3105 ,

     

    Can you share your .pbix file for test?

    Remember to remove the confidential information.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi DonapatiSP_3105 ,

     

    Try:

    % Amended =
DIVIDE (
    CALCULATE (
        COUNT ( Total_Amended[RegistrationNumber] ),
        FILTER (
            ALLSELECTED ( Total_Amended ),
            Total_Amended[New_Status] = MAX ( Total_Amended[New_Status] )
                && Total_Amended[RegionName] = MAX ( Total_Amended[RegionName] )
        )
    ),
    CALCULATE (
        COUNT ( Total_Amended[RegistrationNumber] ),
        FILTER ( ALLSELECTED ( Total_Amended ), [RegionName] = MAX ( [RegionName] ) )
    )
)

    I made a simple sample for reference,you will see below in my example:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my areply as a solution!

     

v-kelly-msft's avatar
v-kelly-msft
Community Support
4 years ago

Hi DonapatiSP_3105 ,

 

Try:

% Amended =
DIVIDE (
    CALCULATE (
        COUNT ( Total_Amended[RegistrationNumber] ),
        FILTER (
            ALLSELECTED ( Total_Amended ),
            Total_Amended[New_Status] = MAX ( Total_Amended[New_Status] )
                && Total_Amended[RegionName] = MAX ( Total_Amended[RegionName] )
        )
    ),
    CALCULATE (
        COUNT ( Total_Amended[RegistrationNumber] ),
        FILTER ( ALLSELECTED ( Total_Amended ), [RegionName] = MAX ( [RegionName] ) )
    )
)

I made a simple sample for reference,you will see below in my example:

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my areply as a solution!