Forum Discussion

markpatton's avatar
markpatton
Icon for Helper I rankHelper I
4 years ago
Solved

Matrix or table with subtotal on one column

Hi,   This seems like it should be simple but I cannot find out how to do it  of even what to search for.   I have data that basically has a number of columns with one being the amount. I want to...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi markpatton 

    Power BI doesn't support you to turn off total from column in value section. You see here I move Vender and Date into Value section in Matrix.

    I suggest you to add the columns as a level in rows section like before. Or you can create measures instead of adding columns in values section.

    Measures:

    M_Vendor = IF(HASONEVALUE('Table'[Line Description]),MAX('Table'[Vendor]),BLANK())
    M_Date = IF(HASONEVALUE('Table'[Line Description]),MAX('Table'[Date]),BLANK())

    Result is as below. In right side, above one is like before, below one is created by measure.

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

markpatton's avatar
markpatton
Icon for Helper I rankHelper I
4 years ago

Thanks, that works if the column is in the rows section but I have moved most of my columns that I don't want to total into the values section. I found that I could format the totals to be white on a white background to remove them but had to remove the alternating grey rows (in style) because I ended up with white text on grey background for alternating rows. Is there a solution like you mentioned for the values columns?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi markpatton 

Power BI doesn't support you to turn off total from column in value section. You see here I move Vender and Date into Value section in Matrix.

I suggest you to add the columns as a level in rows section like before. Or you can create measures instead of adding columns in values section.

Measures:

M_Vendor = IF(HASONEVALUE('Table'[Line Description]),MAX('Table'[Vendor]),BLANK())
M_Date = IF(HASONEVALUE('Table'[Line Description]),MAX('Table'[Date]),BLANK())

Result is as below. In right side, above one is like before, below one is created by measure.

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    You may want to use ISINSCOPE rather than HASONEVALUE since the latter will show a subtotal when a particular invoice has only one Line Description.