Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I have a serious problem: /
How can I get my CA_Year_N static even when I filter on the "Month report filter" ??
I don't want to go through the "modification of interactions" between the graphics because my filter is for all the report.
Is this manipulation possible with Power BI or DAX?
Thank you in advance.
Hi @Moustapha1,
Maybe you could use ALLSELECTED function for the measure formula to ignore the filter selection. Please show us the formula of "CA_Year_N".
Regards,
Yuliana Gu
Hi v-yulgu-msft,
Thank you for your answer.
My CA_Year_N is defined as this, a simple calculation:
CA_Year_N = SUM (Table1 [amount]).
But I tried other formulas like:
CA_Year_N = CALCULATE ([CA_Year_N] FILTER (ALL (DimDate [Date]. [Month]); DimDate [Date]. [Month] <= MAX (DimDate [Date]. [Month])))
or
CA_Year_NTest = CALCULATE ([CA_Year_N] ALL (DimDate [Date]; DimDate [Year]))
But the result is always the same.
The report level filter has the upper hand on all.
Thank you!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |