Forum Discussion

soldous's avatar
soldous
Advocate II
3 years ago

Compare two contexts to the same fact table

I have a report with two Date tables D1 and D2 and two exact dimensions C1 and C2. The reason is that I need two filter contexts to the fact table. D2 and C2 filter the fact table directly and D1 and C1 through the next dimensions.

I chose this approach because the USERELATIONSHIP with just one D and C didn't work as expected. 

In the report, I have two separate sheets (one showing the context of D1,C1 and the second showing the second ones) and two separate filter pages for both. 

But now I need to show the data for all dates from D2 (without additional filter context thanks to other dimensions) but also reflect only the filtered C1 dimension. In other words, I need to compare the whole date history with the filtered one but only for relevant attributes from C1.

 

I tried this but it doesn't work:

CALCULATE([# Rollout Calls],ALLEXCEPT('ETL_CZ_CICX NLP_RESULT_EXT_ATTRIB','ETL_CZ_CICX NLP_RESULT_EXT_ATTRIB'[DIRECTION],'ETL_CZ_CICX NLP_L2_LOV'[L2_CZ],'Date_AllCalls'[Date]),FILTER('ETDW PDW_CELLS_AllCalls',[# Rollout Calls] >0 ))

 

Thanks for any help!

1 Reply