Advanced Calculations Within Table

[NTSIRO]

Good Afternoon,

Below is a screenshot of a table i created. There is two things i am trying to do.

1) Remove the subtotals - how is this done?

2) Get the % of the TIC row with no name (above 0). If we take column 2015/Qrt3 as an example it would be 151/the colum total 343 - is this possible?

Thanks,

[danextian]

Hello,
You can remove subtotals from the formattine pane. Click on a visual then a paintbrush icon will appear on the right portion of the designer
You can remove blank category items from the visual filters. Under advanced filters, select does not contain blank. The visual filters option will appear on the right side of the designer when you click on a visual.

[NTSIRO]

Thanks! I was able to take away the subtotals.

For the blank caterory items is there anyway to divide them by the total? and or perfom calculations using that row? 

[danextian]

In query editor, is that blank a null or a white space. This could be the formula :

Measure =if(table[column] <> blank(), divide( [your measure], calculate( [your measure], table[column] = blank() ) ) )

This will not return a value if the row is blank(). It is blank() if it shows as blank in the query editor. If it's a white space, replace it with double quotes "".