Forum Discussion

waqarqtrz's avatar
waqarqtrz
Frequent Visitor
1 year ago
Solved

How do I show multiple Values in a Matrix column one after the other and not alternating?

I have the following table I am trying to replicate in a Power BI Matrix: I recognized this involves creating measures such as a measure that ignores any filters from the columnar categories (...
Need Help
  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    1 year ago

    Hi waqarqtrz , To achieve the output like in excel you have to remove Participant Grouping L2 field from your Columns section of the matrix and create indivudual measures for External, TCPT, TCYT, TCYT US, Total, Total% and etc... by applying filters inside the measures and pull the measures in Values section of the matrix like below

     

    Sample Output:

    Sample Dax for External Measure: (Create other measures for TCPT, TCYT, TCYT US, Total, Total%)

    External = CALCULATE(sum('TMO'[Txn_Amt_Balance]),'TMO'[Participant Grouping L2] = "External")

     

    If I answered your question, please mark my post as a solution.

     

    Thanks,

    Jai 

Jai-Rathinavel's avatar
Jai-Rathinavel
Icon for Super User rankSuper User
1 year ago

Hi waqarqtrz , To achieve the output like in excel you have to remove Participant Grouping L2 field from your Columns section of the matrix and create indivudual measures for External, TCPT, TCYT, TCYT US, Total, Total% and etc... by applying filters inside the measures and pull the measures in Values section of the matrix like below

 

Sample Output:

Sample Dax for External Measure: (Create other measures for TCPT, TCYT, TCYT US, Total, Total%)

External = CALCULATE(sum('TMO'[Txn_Amt_Balance]),'TMO'[Participant Grouping L2] = "External")

 

If I answered your question, please mark my post as a solution.

 

Thanks,

Jai