My question is simple realy but i havn't found an answer anyware.
I have a simple table with one colum (dimension) detalies the names of my employees, and the second colum (dimension) their status (active, MLOA etc.)
How can i make the table to show only the employees with a specif dimension, without it being impacted by filter and aggreagation options.
I tried set-analyis, but it wotks only with measure.....
if you use set analysis in measure expression and specify in the set the desired dimension value, you will obtain exactly what you need in your dimension in the table.
Filter will not impact on that dimension for that table.