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 all,
i have a simple model with one fact table and two dimensions, calendar and projects.
I have to calculate some columns/measure:
Any idea?
I can do a simple .pbix file it it's needed.
Regards, Francesco
Solved! Go to Solution.
Hi, @FrancescoSCP
Yes, you cannot create a dynamic calculated column based on a measure.
The project_state column in your file, if you want it to change dynamically, then you need to use the measure instead of the calculated column.
And you really can't put the measure in the column of the matrix, it is recommended that you consider using the table visual, you may need to change the data structure if necessary to get the expected result you want.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @FrancescoSCP
Yes, you cannot create a dynamic calculated column based on a measure.
The project_state column in your file, if you want it to change dynamically, then you need to use the measure instead of the calculated column.
And you really can't put the measure in the column of the matrix, it is recommended that you consider using the table visual, you may need to change the data structure if necessary to get the expected result you want.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, it seems that i can't achive my goal only with measures/columns so i've changed the data model to do this. Thanks anyway for your support.
Regards.
Francesco
No one?
Can you post a depiction of the expected result?
Proud to be a Super User!
Paul on Linkedin.
Any suggestion?
Regards.
Francesco
The column project_state in the .pbix file that i've uploaded has to work. It seems that i can't create a dynamic calculated column based on a measure
Here's a simple .pbix file with an example https://we.tl/t-fHs3xZ1pxl
As you can see the Running_Closed measeure works good: if no year is selected than it's "*" else it shows the correct value.
The Project_State column isn't working. I must use a column because i have to use it in a Matrix on columns to split the value.
Any ideas?
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |