Forum Discussion
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...
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?
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 "".
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 "".