Forum Discussion
jasonyeung87
Helper V
Helper VFiltering data based on 2 columns in dataset
Hi, I'm using the table visualization to display data from an analysis services database. The data looks similar to the following: Customer Name User Name Jason Jay John John Juli...
Have you considered using a DAX measure?
how is your data structured? is it in columns in a fact table?
if so then you could add a column with an IF statement as an example
User Names Match = if(customer name = user name , "Match" , "Does not Match" )
then add the column to a filter for the matrix and select "Match" and that should do it
jasonyeung87Helper V
Helper VHi Dnerada,
The data is from the Analysis Services database and is not structured with dim / fact tables. We're connecting to it live, so we can't modify the Cubes. I'll see if I could add a measure, but because it is a live connection, it may not be possible.
Sincerely,
Jason
You should have no issues creating a report level meaure with a live connection