SelectedValue w/Calculation group

[Dellis81]

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 calc group

The first tab of attached file - excludes interaction w/the calculation group - and works perfect.

The second tab, with interactoin - results in a blank value.

Selected = 
Var CenterDesc = if(HASONEVALUE(CenterSetup[Description]),selectedvalue(CenterSetup[Description]),SELECTEDVALUE(CenterSetup[Group Description]))
Return if(HASONEVALUE(CenterSetup[Group Description]),CenterDesc,"Select Single Item")

The calculation group only references the "Calendar[Fin Year] column..

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

How can the initial "Selected' measure  be tweaked so it works with teh calculation group toggled.

Thanks!  I bet this is simple!

daryl

[parry2k]

@Dellis81 Glad it worked out. Yes, it is very powerful but need to be careful when using Calculation Groups and need to think thru everything. 

[parry2k · Accepted solution]

@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.⚡

[Dellis81]

Thank you!   Finding calc groups to be very powerful - but yet difficult to manage with these type unexpected nuances,   You have always been helpful - thank you!