Forum Discussion

NTSIRO's avatar
NTSIRO
Regular Visitor
8 years ago

Advanced Calculations Within Table

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,

3 Replies

  • danextian's avatar
    danextian
    Super User
    8 years ago
    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's avatar
      NTSIRO
      Regular Visitor
      8 years ago

      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's avatar
        danextian
        Super User
        8 years ago
        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 "".