Forum Discussion

MYue's avatar
MYue
New Member
2 years ago
Solved

How to prevent matrix summarize certain fields

I structured a matrix using some dummy data:

and this is how it look like when I put them in a matrix.

In this sample, there are 2 positions that have different unique position ID that issued by same issuer.  So I put Issuer and Position ID into "rows" and various "commitments", "maturity" into "Values".  Everything went well here.

 

When I click the minus sign on the left, it fold and display the following:

 

I like this feature, however, Is there a way to not summarized the field and let it be empty(blank)?

For example, the summation of commitments are reasonable, but for Maturity, it only allow me to select between earlist, latest, count, count(distinct).   None of it really make sense in this scenario, is there a way to leave it empty?

 

 

Thank you!

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MYue ,

     

    You might consider using a measure instead.

    Here are the steps you can follow：

    1. Create measure.

    Measure =
IF(
    HASONEVALUE('Table'[Position ldentifier]),MAX('Table'[Maturity]),
    IF(
        HASONEVALUE('Table'[Security Name]),BLANK()))
    Measure2 =
CONVERT([Measure], DATETIME)

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

2 Replies

  • danextian's avatar
    danextian
    Super User
    2 years ago

    Hi MYue ,

     

    Anything you put in matrix values tile will be summarized as it is meant to aggregate the cross section of rows and columns. If you don't want it summarized, please put the field in either row or column tiles or use a table instead.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi MYue ,

     

    You might consider using a measure instead.

    Here are the steps you can follow：

    1. Create measure.

    Measure =
IF(
    HASONEVALUE('Table'[Position ldentifier]),MAX('Table'[Maturity]),
    IF(
        HASONEVALUE('Table'[Security Name]),BLANK()))
    Measure2 =
CONVERT([Measure], DATETIME)

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly