Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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!
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
10 | |
9 | |
8 | |
6 |
User | Count |
---|---|
20 | |
19 | |
18 | |
13 | |
10 |