Forum Discussion

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", NETO_SALES,

"COGS", COGS

)

_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", COGS

)

But _Test2 measure does not retur percent on each code, only total

How return values for each code?

Tips and Tricks

Digger
4 years ago
SOLVED
VAR NETO_SALES = CALCULATE([Sales],ALL())

3 Replies

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
  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)
Digger
Post Patron
4 years ago
SOLVED
VAR NETO_SALES = CALCULATE([Sales],ALL())

Related content