expend table give me the wrong number

[Anonymous]

hi i have a measure that take all the [sihpped product - return product ]

this is the measure :

INB=
var _MaxDate = MAX(DimDate[Date])
VAR _INB =
CALCULATE(
CALCULATE(
CALCULATE(COUNT('FACT'[DOCDES]),
    FILTER('FACT', 'FACT'[DOCDES] = "Shipped"),FILTER(DimDate,DimDate[Date]<=_MaxDate)),ALL(DimDate))
-
CALCULATE(
    CALCULATE(COUNT('FACT'[DOCDES]),
    FILTER('FACT', 'FACT'[DOCDES] = "return"),FILTER(DimDate,DimDate[Date]<=_MaxDate)),ALL(DimDate))
)
RETURN 
IF(_INB<0, BLANK(), _INB)

when i insert the mesure to a table i got the coorect numbers

part name (from dim parts)	INB
x	3
total	3

but when i add customer name from the dim customer the number are incorrect 

part name (from dim parts)	customer name	INB
x	1	1
x	2	1
x	3	5
total		3

the total will be fine after i will add the customer name but the deatiles are wrong 

Thanks 

[v-zhangti]

Hi, @Anonymous 

Can you provide some source data for testing? It can be an excel picture or a simple pbix document to remove sensitive information.

Look forward to your reply.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Try like

INB=
var _MaxDate = MAX(DimDate[Date])
VAR _INB =
CALCULATE(COUNT('FACT'[DOCDES]),
FILTER('FACT', 'FACT'[DOCDES] = "Shipped"),FILTER(ALL(DimDate),DimDate[Date]<=_MaxDate))
-
CALCULATE(COUNT('FACT'[DOCDES]),
FILTER('FACT', 'FACT'[DOCDES] = "return"),FILTER(ALL(DimDate),DimDate[Date]<=_MaxDate))

RETURN
sumx(values(parts[part name]), IF(_INB<0, BLANK(), _INB) )

[Anonymous]

it not working,

i'm getiing blank