Forum Discussion

newtobi23512's avatar
newtobi23512
Regular Visitor
8 years ago

How can i hide grouped data while keeping the data

Hello, I am fairly new to Power BI and I calculated the percentage of column totals. I would just like to see the Black portion but keep the calculation as shown (1.92%, 2.44%, 2.53%). Getting rid of the green. Is there a way to do this?

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    8 years ago
    Hi newtobi23512,

    Don't know how you calculated the measure bit you need to have a neasure that looks somethong lile this

    Dealer % =
    DIVIDE (
    CALCULATE ( SUM ( TABLE[column] ); Table[Dealer segment group] = "Wholesaler" );
    CALCULATE ( SUM ( TABLE[column] ); ALL ( Table[Dealer segment group] ) )
    )

    Change the table names and columns names by the ones in your table.

    Not at computer so DAX syntax may have to be adjusted a little.

    Regards
    MFelix