Forum Discussion

ghaines's avatar
ghaines
Icon for Resolver I rankResolver I
3 years ago
Solved

Using same column in rows and columns of matrix visual: Detecting row vs column context

I have different bands of customers defined based on their average monthly sales.  I'd like to display a matrix of migration between the bands i.e. how many customers have moved from band x to band y...
DAX
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    ghaines No, DAX is pretty clueless about stuff like that. There is ISFILTERED and ISCROSSFILTERED but that's about it.

tpaliwal's avatar
tpaliwal
Frequent Visitor
2 years ago

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.

  • ghaines's avatar
    ghaines
    Icon for Resolver I rankResolver I
    2 years ago

    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.

    • tpaliwal's avatar
      tpaliwal
      Frequent Visitor
      2 years ago

      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!

      • ghaines's avatar
        ghaines
        Icon for Resolver I rankResolver I
        2 years ago

        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.