Forum Discussion
Retaining certain values so they can be compared against
Hi Anonymous, try this: https://drive.google.com/file/d/1-2UHhq7J4C5Y0csqQCrr3nJMhX12DJVt/view?usp=sharing
Add a new flag to identify the fixed areas and add a new table for just the optional area values, then use the 'Show Area' measure as a 'greater than 0' filter on your visual:
Show Area =
CALCULATE(
COUNTROWS('Table')
,'Table'[Fixed Flag] = TRUE()
|| ISFILTERED('Optional Area'[Optional Area]) = TRUE()
&& 'Table'[Area] IN ALLSELECTED('Optional Area'[Optional Area])
, 'Table'[Area] = SELECTEDVALUE('Table'[Area])
)Feels fairly wonky, but if it works, it works. Remember to lock and hide the filter, so it can't be removed.
Resolver IIHi Anonymous, try this: https://drive.google.com/file/d/1-2UHhq7J4C5Y0csqQCrr3nJMhX12DJVt/view?usp=sharing
Add a new flag to identify the fixed areas and add a new table for just the optional area values, then use the 'Show Area' measure as a 'greater than 0' filter on your visual:
Show Area =
CALCULATE(
COUNTROWS('Table')
,'Table'[Fixed Flag] = TRUE()
|| ISFILTERED('Optional Area'[Optional Area]) = TRUE()
&& 'Table'[Area] IN ALLSELECTED('Optional Area'[Optional Area])
, 'Table'[Area] = SELECTEDVALUE('Table'[Area])
)
Feels fairly wonky, but if it works, it works. Remember to lock and hide the filter, so it can't be removed.
Thank you so much! Is there any way you could share the pbix file? I'm struggling to replicate
- Russell-PBI
Check out the link in my post 😉
Perfect thanks again, I got it to work!!