question about context overwrite

[ryan-gao]

Hi everyone

     As I know  calculate can replace the original filter context(query context) with its inside filters, but i feel puzzled by this simple case.

IF there is no context overwrite, i have no doubt it should return blank, but when apple is overwrite to tv,why result is still blank?

Thanks in Advance

[v-ljerr-msft]

Hi @ryan-gao,

In this scenario, you may need to use ALL function to firstly ignore any filters that might have been applied, then replace with a new filter context. The formula below is for your reference. 

test =
CALCULATE (
    CALCULATE ( COUNTROWS ( '表2' ), '表2'[name] = "tv" ),
    FILTER ( ALL ( '表2' ), '表2'[category="electric"] )
)

Regards

[ryan-gao]

Thanks @v-ljerr-msft 

In this scenario, I want the red box of the pivot table to retrun 1,your formula can not do this, but I found the final answer . it is "autoexists" . so if rows and columns of the pivot table came from the same table ,it automaticly remove the nonexist combinations first, no matter  how the filter context in calculate defines  ,it will always return blank.

 hope you can understand my poor english

[ryan-gao]

anyone can help?     

thanks in advance