Redundant Data in Table

[Justair07]

Hello,

I can't figure out why my fields are redundant when I go from 3 fields to 2 fields (see pictures).

I also included a picture of my relationships in case that is one of the potential reasons:

The KPI Test fiels is a custom field as well:

KPI Test = 
VAR Down =
    UNICHAR ( 11167 )
VAR UP =
    UNICHAR ( 11165 )
RETURN
    IF ( [Daily DPMU] < 490, Down, UP ) & " "
        & FORMAT ( [Daily DPMU], "0" )

[v-frfei-msft]

Hi @Justair07,

That should be the issue of your relationships between tables. Did you create your measurs [Daily DPMU] and [Daily DPMU] based on different tables? Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

Regards,

Frank

[Justair07]

@v-frfei-msft Hi and thank you for the reply. I wish I could share but the data is pretty confidential. But to answer your question, yes Daily DPMU is a custom measure that calculates DPMU (very common metric in manufaturing busnisess) for the previous workday:

Daily DPMU = 
IFERROR (
    CALCULATE (
        ( SUM ( tblKPIData[Footage Returned] ) / SUM ( tblKPIData[Footage Shipped] ) ) * 1000000,
        tblDates[Date]
            = IF (
                WEEKDAY ( TODAY (), 3 ) < 4,
                TODAY () - 1,
                TODAY ()
                    - ( 7 + WEEKDAY ( TODAY (), 3 ) )
            )
    ),
    ""
)

All refrenced fields are from the same table (tblKPIData). This makes me think it's not a relationship issue.

When I changed the KPI Test from a custom COLUMN to a custom MEASURE, that seems to have fixed the issue. Does this makes sense?