Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have measures
How return values for each code?
Solved! Go to Solution.
SOLVED
VAR NETO_SALES = CALCULATE([Sales],ALL())
@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
)
@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)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 74 | |
| 50 | |
| 49 | |
| 44 |