Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello
To get the latest data out of the fact, I made a calculated column in Power BI, which I can use to filter my page.
If I choose the value 1 for that filter, I will get the latest month with data in the fact.
When I copy this calculated column to Report Server, I get an error.
I tried using selectedvalue but then my filter never finds a match, so only returns 0
Below my code and the error message (sorry, the formatting doesn't transfer for some reason)
Are you sure this is a measure in Power BI Desktop? Smells more like a calculated column.
Oops, indeed!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 6 | |
| 3 | |
| 3 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 10 | |
| 5 | |
| 5 | |
| 4 | |
| 3 |