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.
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.
@Anonymous,
Values in a calculated table are fixed. You may use it in a measure.
I do not understand what you mean by 'fixed'.
Can you explain more please?
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |