Forum Discussion

Dellis81's avatar
Dellis81
Post Prodigy
5 years ago
Solved

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

 

 

Need Help
  • parry2k's avatar
    parry2k
    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.⚡

     

     

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    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.⚡

     

     

    • Dellis81's avatar
      Dellis81
      Post Prodigy
      5 years ago

      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!

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    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.