Forum Discussion
Using same column in rows and columns of matrix visual: Detecting row vs column context
ghaines No, DAX is pretty clueless about stuff like that. There is ISFILTERED and ISCROSSFILTERED but that's about it.
Hi,
I'm trying to create a similar matrix as I have produced through sample dataset.
I have different Lifecycles and I'm trying to show the migration of customers through different lifecycle over time.
My question is around how do I use same field in rows and columns. And also make it dynamic based on the selected time period.
My matrix was made with two disconnected tables that were identical except for name, and were used for the row and column axes of the matrix. I could then use the values in row and column to define the logic of the dax expression that created the return value. I don't think it's possible to read two different table contexts from row and column contexts.
Hi Ghaines,
Is it possible for you to share the PBIX file so that I can see the logic and use of DAX?
Appreciate your help!
No, sorry. The dax expressions and disconnected tables contain strata of unit sales/month for different customers that would give some indication of our financials, and there is identifying information throughout.
Totally understand, no worries.
If there is a way for you to show the DAX by changing the names that will be helpful.
If not possible then that's okay.
Thank you!