Forum Discussion

Justair07's avatar
Justair07
Resolver I
7 years ago

Redundant Data in Table

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" )
Need Help

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    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's avatar
      Justair07
      Resolver I
      7 years ago

      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?