Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
soldous
Advocate II
Advocate II

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.

Capture.PNG

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 1
lbendlin
Super User
Super User

Can you describe the business problem you are trying to solve?

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.