Filtering data without getting repeated data when drilling down

[jacostabarbosa]

Hi all, I'm currently trying to filter gross sales by specific order types in such way that if I add date and order type to the row field in a matrix it'll show the data distributed by date and order type. However, the measure seems to work only with date as follows:

Once I keep drilling down to the next level which are the order types instead of only showing the order types that i need (035,036,037,038,040,041,042)it shows all of them and even worst with the same value which is wrong.

this is my measure:

COF_Warranty costs =

CALCULATE(

    [Gross Sales],

    'ANZ  Sales'[Order Type]

        IN { "035", "036", "037", "038", "040", "041", "042" }

)

can anyone give me some hints on what needs to be added to the measure? 

Thanks 

[jacostabarbosa · Accepted solution]

I've modified my measure and it's working fine now

COF_Warranty costs =

CALCULATE(

    SUM('ANZ  Sales'[Gross Sales AUD]),

    FILTER(

        'ANZ  Sales',

        'ANZ  Sales'[Order Type] IN {"035", "036", "037", "038","040","041","042"}

    )

)

[lbendlin]

the measure is likely fine.  It's your data model that needs fixing. The same value down a column indicates a mis-wired data model.

[jacostabarbosa]

The model is correct it was just the incorrect measure.