Measure shows only total

Hi Anonymous ,

This as to do with the context of your measure, when you are making the visual based on the EAN table you cannot make the calculation based on the Sales[EAN] code because the row context is different, what happens is that you are making the filter context for the visual based on one value from one table but then calculating the measure on the Sales side.

This is even more pressing since you have a one to many relationship going from EAN to Sales so when you calculate a value from the Sales to the EAN since the relationship is going the other way is like you don't have any relation in place so it returns a single value for all the rows.

In your measure the allexcept part is redundant since the filter context comes from the EAN redo the measure to:

Sales/Day All Time = 
        CALCULATE ( 
            SUM ( 'Sales/Day'[Sales] ) ; 
            FILTER ( 
                 'Sales/Day'  ;
                'Sales/Day'[Date] <= MAX ( 'Sales/Day'[Date] )
            )  ;
            FILTER ( 
                ALLSELECTED ( EAN[EAN13] ) ; 
                EAN[EAN13] <> BLANK()
            )
        )
        /
        CALCULATE ( 
            SUM ( 'Sales/Day'[Sellable_1] ) ; 
            FILTER ( 
                 'Sales/Day' ;
                'Sales/Day'[Date] <= MAX ( 'Sales/Day'[Date] )
            ) ;
            FILTER ( 
                ALLSELECTED ( EAN[EAN13] ) ; 
                EAN[EAN13] <> BLANK()
            )
        )

As you can see below the measure Sales/Day All Time 2 (adjusted gives the correct value).

See attach PBIX file.

Regards,

MFelix