Forum Discussion
Get all row from a table based on calculated Formula
Hi,nicolast29
I am glad to help you.According to your description, you want to achieve the following effect in the matrix: dynamically filter the table in the matrix to display a row of data in the Sales table that corresponds to the selected metric (based on the MagKey rows and the filter criteria in the measure together, not only through the Magkey rows).
Unfortunately this is not possible, you can only filter another table by fields in the table (normal columns or calculate columns).
You can try to add [color] to the row field of the matrix (although this is similar to adding a Slicer)
like this:
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,nicolast29
I am glad to help you.
According to your description, you want to achieve the following effect in the matrix: dynamically filter the table in the matrix to display a row of data in the Sales table that corresponds to the selected metric (based on the MagKey rows and the filter criteria in the measure together, not only through the Magkey rows).
Unfortunately this is not possible, you can only filter another table by fields in the table (normal columns or calculate columns).
You can try to add [color] to the row field of the matrix (although this is similar to adding a Slicer)
like this:
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.