cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DanBusIntel Member
Member

SELECTEDVALUE not working in a summarized table

Hi

I have a 1st report page (overview) where the user can drill-through to the 2nd report page (specific) on a centre number.

Within the specifc report page I can see the drill-through has worked and the drill-through centre is filtering the specifc report as expected. I have used the SELECTEDVALUE() function to place the specific centre in a card visual.

 

I then create a table based on the following:
tCountOfEntriesByBandingAndYear =
     ADDCOLUMNS(
                            SUMMARIZE(
                                                Learner_Progress,
                                                Learner_Progress[certificationdate],
                                                Learner_Progress[cBandingDaysBetweenRegistrationAndCertification]
                                                 ),
                            "CountOfEntriesByBandAndYear", CALCULATE( COUNTA( Learner_Progress[cBandingDaysBetweenRegistrationAndCertification] ) )
                             )

 

The above table is calculating based on all centres and not just the single centre that was in the drill-through.
I have tried many variations to try and get the filtering working on the drill-through centre only but to no joy. Clearly, I don't want to hard code anything so it needs to be dynamic.

 

Please can you help?

Thanks.

2 REPLIES 2
Community Support Team
Community Support Team

Re: SELECTEDVALUE not working in a summarized table

@DanBusIntel,

 

Values in a calculated table are fixed. You may use it in a measure.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DanBusIntel Member
Member

Re: SELECTEDVALUE not working in a summarized table

I do not understand what you mean by 'fixed'.

 

Can you explain more please?

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)