ALL () function not working as expected

Question

Hi,&nbsp;I've tried searching but couldn't find the solution&nbsp;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 = calculate(table1[refund value]) / calulate(table1(sale value), all(table2[IND])&nbsp;I have a bookmark on the report page applying a page filter to turn the IND column to 1, however when I do this my % sales measure is applying the IND measure so giving me infinity for most of my values. I wouldn't expect the IND measure to be applied because of the ALL function.&nbsp;&nbsp;Help please!&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

Nevermind,&nbsp;&nbsp;I've solved it.&nbsp;&nbsp;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...&nbsp;

Forum Discussion

ALL () function not working as expected

2 Replies

Related content

rank() function not working as expected (NOT USING RANKX)

UNION Function not working as expected

All Function Not Working as expected !!!

dbt job schema not working as expected

ALL() function not working as expected