Forum Discussion

MrMilk's avatar
MrMilk
Icon for Helper I rankHelper I
3 years ago

Sales target does not appear

Hi all i have a sales fact table with salesman code and a sales target table with data, salesman code and value. In pbi if in a month the salesman had nothing in sales the sales target does not appe...
MrMilk's avatar
MrMilk
Icon for Helper I rankHelper I
3 years ago

the formula should be

 

HasSales = IF(
CALCULATE(
SUM(SalesFactTable[Sales]),
ALLEXCEPT(SalesFactTable, SalesFactTable[Salesman Code], Dates[Month])
) > 0,
1,
0
)

but if i dont have sales the sales code does not even appear

Mrxiang's avatar
Mrxiang
Icon for Helper II rankHelper II
3 years ago

Can you provide the PBIX file?