Sales amount measure not displaying for all the rows

[RADHIKA_3022]

Hi ,

I want to see the VanArsdel Sales in all the rows. But I am seeing the value only against "VanArsdel". Please see the below image. And the DAX I have used, 

VanArsdel Sales =

CALCULATE(

Sales[Sales Amount],

FILTER(

ALL(Products[Manufacturer]),

Products[Manufacturer]="VanArsdel"

))

[AntrikshSharma · Accepted solution]

@RADHIKA_3022 Is that "Sales Amount" a column and not a measure? if yes then that is cross filtering your measures. Use this instead:

VanArsdel Sales =
CALCULATE (
    Sales[Sales Amount],
    FILTER (
        ALL ( Products[Manufacturer], Products[Sales Amount] ),
        Products[Manufacturer] = "VanArsdel"
    )
)

Or maybe the Manufacturer column isn't coming from Products table?

[RADHIKA_3022]

Yes you are right,  the Manufacturer column isn't coming from Products table, it's coming from Manufacturer table !!

Thanks a lot for responding Antriksh !