Forum Discussion

Digger's avatar
Digger
Post Patron
4 years ago
Solved

Divide does not show result

I have measures _Test1 = VAR NETO_SALES = CALCULATE([Sales]) VAR COGS = CALCULATE([COGS],FILTER(Table,[Group]="COGS")) RETURN SWITCH ( SELECTEDVALUE ( Lists[Budzet] ), "NETO SALES", NE...
Need Help
Show and Tell
Tips and Tricks
  • Digger's avatar
    Digger
    4 years ago

    SOLVED
    VAR NETO_SALES = CALCULATE([Sales],ALL())

amitchandak's avatar
amitchandak
Super User
4 years ago

Digger , seem like there some white space or special character in COGS, try like

 

_Test2 =

VAR NETO_SALES = CALCULATE([Sales])
VAR COGS_1 = CALCULATE([COGS],FILTER(Table,[Group]="COGS"))
VAR COGS = DIVIDE(COGS_1,NETO_SALES)

RETURN

SWITCH (
SELECTEDVALUE ( Lists[Budzet] ),
"NETO SALES", DIVIDE(NETO_SALES,NETO_SALES),
 COGS
)

Digger's avatar
Digger
Post Patron
4 years ago

amitchandak No you wrong, as you can see _Test1 measure working very well as does not have divide function, but if divide funcion exists in measure it will not work

 

ithink there problem with VAR NETO_SALES = CALCULATE([Sales])  as there not exist codes starting from 6, and PBI just divide from 0, NETO_SALES should be fixed value in all cases, as i need each code starting from 6 divide from 62124.09 (total neto_sales)