Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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)
User | Count |
---|---|
81 | |
75 | |
73 | |
42 | |
36 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |