Forum Discussion
How to include a dinamic variable into a temporary column
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Please find a sample data: https://transfer-vinci-energies.netexplorer.pro/fdl/eSj2RoLNz_SPHwUux61wQwModc54Vv
Please note that I don't want to create a calculated table, but rather a measure that can count how many active students are present on any date selected by the user using a slicer. So i'm considering this temporary table inside a measure, something like this:
Active Students =
VAR
You need to protect SELECTEDVALUE from FILTER. Move it out into a variable.
Active Students =
var sd = selectedvalue('Calendar'[Date])
...
FILTER('REGISTRATION', 'REGISTRATION'[Date] < sd,
...
etc
Can you please re-enable the download?
Here's the link: https://transfer-vinci-energies.netexplorer.pro/dl/RY8c3ksKxYBsqMupb3xxHTSvLBulUP
I tried your suggestion but PowerBI retrieves the following error:
"It's not possible to find the table Active Registrations".Now, granted, this is not very fast. But it's something you can start from.
Here's the link: https://transfer-vinci-energies.netexplorer.pro/dl/RY8c3ksKxYBsqMupb3xxHTSvLBulUP
I tried your suggestion but PowerBI retrieves the following error:
"It's not possible to find the table Active Registrations".