Forum Discussion

Justair07's avatar
Justair07
Icon for Resolver I rankResolver 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...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity 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
Icon for Resolver I rankResolver 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?