Forum Discussion
Dynamic table visual based on Slicer selection
Hi Anonymous ,Thanks for your response.
I have tried with the above DAX but it is showing only MAX records for me each country,state,city.
I have tried to replace max with selectedvalue it showing blank results.
Could you please tell me how you are getting all records using MAX.
Thanks
Hi Kushalavareddy ,
First of all, if you want to use a metric to return an entire column, you can't do it, you can only return a single value.
You say selectvalue returns a blank value because since there are multiple elements in a column that are not selected in the filter, he will return a blank value by default.
The best solution is to remove the aggregation effect from the amout columns:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.