Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |