topic Re: Sales amount measure not displaying for all the rows in DAX Commands and Tips

Sales amount measure not displaying for all the rows

Anonymous — Sat, 28 Nov 2020 05:48:30 GMT

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"

))

Re: Sales amount measure not displaying for all the rows

AntrikshSharma — Sat, 28 Nov 2020 08:45:08 GMT

Anonymous 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?

Re: Sales amount measure not displaying for all the rows

Anonymous — Sat, 28 Nov 2020 11:11:38 GMT

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 !