Forum Discussion
Dellis81
5 years agoPost Prodigy
SelectedValue w/Calculation group
Hello! Attached file: https://1drv.ms/u/s!AmBVCme14p7xszKiXcB2IOJ4Fwcw?e=c1JRod I am wanting to return the value of a selected matrix row works perfectly for a tab w/no interaction with the cal...
- 5 years ago
Dellis81 make the following change in the calculation group
IF ( ISSELECTEDMEASURE ( [Selected] ), [Selected], VAR ExclCurrentYrAvg = AVERAGEX ( FILTER ( VALUES ( 'Calendar'[Fin Year] ), 'Calendar'[Fin Year] < YEAR ( TODAY () ) ), CALCULATE ( SELECTEDMEASURE () ) ) VAR AnnualValue = CALCULATE ( SELECTEDMEASURE () ) VAR ReportValue = IF ( HASONEVALUE ( 'CALENDAR'[Fin Year] ), AnnualValue, ExclCurrentYrAvg ) RETURN ReportValue )Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡