Forum Discussion

DanDan's avatar
DanDan
Regular Visitor
5 years ago
Solved

Removing repeated values in matrix

Apologies if this is a bit basic and my Subject title is vague - I'm a strong beginner at best!   I've two matrices and a filter with 'Budget' selected. The difference between the matrices is that ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi DanDan ，

    You can update the measure [Budget Cost ] as below and create another new measure to replace it on the matrix, please find the details in the attachment.

    Budget Cost = 
IF (
    (
        ISINSCOPE ( 'Mapping'[Line Item] )
            && NOT ( ISINSCOPE ( 'ActualsCosts'[Item Description] ) )
    )
        || (
            NOT ( ISINSCOPE ( 'ActualsCosts'[Item Description] ) )
                && ISINSCOPE ( 'Supplier'[Supplier Name] )
        ),
    SUM ( BudgetCosts[Value] ),
    BLANK ()
)
    Measure = SUMX(VALUES('Mapping'[Line Item]),[Budget Cost])

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi DanDan ，

You can update the measure [Budget Cost ] as below and create another new measure to replace it on the matrix, please find the details in the attachment.

Budget Cost = 
IF (
    (
        ISINSCOPE ( 'Mapping'[Line Item] )
            && NOT ( ISINSCOPE ( 'ActualsCosts'[Item Description] ) )
    )
        || (
            NOT ( ISINSCOPE ( 'ActualsCosts'[Item Description] ) )
                && ISINSCOPE ( 'Supplier'[Supplier Name] )
        ),
    SUM ( BudgetCosts[Value] ),
    BLANK ()
)
Measure = SUMX(VALUES('Mapping'[Line Item]),[Budget Cost])

Best Regards

FarrukhData's avatar
FarrukhData
Frequent Visitor
1 year ago

Hi,
what if we can't sum because we have text repeating?

orange is rows and black is values. I don't want black to repeat.