Forum Discussion
Dynamic Table - Not Affected by Source Table fields except one Field
Hi All, I am new to Power BI. Please assist, urgent help needed. As you can see in below Gantt chart, I am trying to display resource allocation with respect to Skills (present in vertical redacte...
I am able to solve the issue. I have created a disconnected table and used treatas function to make the visual relationship between tables. I have used following expression in measure filed in disconnected table
Hi Anonymous,
Your DAX is creating a calculated table. However caclulated tables are only refreshed when the model is loaded with data. Eg they are never dynamic. The reason it therefore shows blank is there is no SELECTEDVALUE so that line returns blank.
You could create a dynamic table in a variable within a measure but I suspect there might be easier ways of achieving what you are trying. Are you able to share a demo pbix file?
Thanks
Ben