Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Matrix using multiple columns w/ same pick list values

Hi all,   Been searching for some time and haven't found a good solution to an issue we're having in terms of building out a matrix that takes multiple columns that all have the same pick list valu...
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    See if this works:

    You can get the following by unpivoting and a simple SUM measure

    I've attached the PBIX file

    Please beware you will need to change the source of the file