Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

ALL () function not working as expected

Hi,   I've tried searching but couldn't find the solution   I have a calculated measure calculating refund % sales in table 1. In table 2 I have an IND for a category (1 or 0). % measure = calc...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Nevermind, 

     

    I've solved it. 

     

    I had a seperate IS NOT filter from table2[unrelated_col2] filtering on the report page. I've no idea why this affected my % sales measure because the sum(table1[sales value]) will always comply with the IS NOT filter on the page but it was...