Forum Discussion

markpatton's avatar
markpatton
Helper 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.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi markpatton 

Turn on "Per row level" function in "Subtotal" in Format, and then turn off the subtotal in the level which you don't need.

Step 1:

Step 2:

Result is as below.

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.

KeshavK0310's avatar
KeshavK0310
Regular Visitor
2 years ago

Now, I donot get to turn off row level for particular column in power bi.