11-30-2018 10:31 AM
Good afternoon to all (here in Brazil is a beautiful Friday afternoon).
I would like to know if it is possible to disable the subtotal of only one column in Power BI in an matrix?
In this matrix I have some numerical columns where the subtotal does its paper well, and I have a column of text (justification of values that are negative).
In this justification column, I wish I did not have the subtotal (because as it is text, it brings either the First record or the Last one).
11-30-2018 10:45 AM
If the values being subtotaled could be made into a measure you could use HASONEVALUE to only calculate the measure when there is one value and you could use the IF statement to set the measure to BLANK() so the subtotals will always be blank.
Not sure it's what are asking, maybe a screenshot of your data might help.