Forum Discussion
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...
MFelix
Super User
Super UserHi 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
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