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 ...
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

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