Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI,
I have two matrix that interact with each other. Due to this matrix- 2 is having a filter like below
now I have a measure
AnalysisDateAmount = CALCULATE (
SUM ( Table_1[Amount] ),
FILTER (
ALL ( Table_1[File Category] ),
Table_1[File Category] = "Analysis Date"
))
But the date=12/31/2013 filter is getting applied and i'm not getting required result. This filter happened due to interaction and was not created by me. Is there a way I can remove that filter while calculating the measure.? I cannot turn of intercation because of other columns in the table
Solved! Go to Solution.
Hi @Anonymous ,
You may use "Edit interactions" feature to determine which visual be effected by another visual following steps below. See the similar case .
You can learn more: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You may use "Edit interactions" feature to determine which visual be effected by another visual following steps below. See the similar case .
You can learn more: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI @Anonymous ,
Without any data or example is difficult to give an answer but you can try to add something similar to this:
AnalysisDateAmount =
CALCULATE (
SUM ( Table_1[Amount] ),
FILTER (
ALL ( Table_1[File Category] ),
Table_1[File Category] = "Analysis Date"
),
ALL ( Table[Date] )
)
Or
AnalysisDateAmount =
CALCULATE (
SUM ( Table_1[Amount] ),
FILTER (
ALL ( Table_1[File Category] ),
Table_1[File Category] = "Analysis Date"
),
ALLSELECTED ( Table[Date] )
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português