Forum Discussion
Post PatronConvert value from measure to a Constant Value
Hi roncruiser ,
Modify your variable as below:
Variable1 = SUMX ( FILTER ( ALL (maintable[position],maintable[intensity]), maintable[position] = 1 && maintable[intensity] = 0 ), maintable[Value] )Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Post Patron
Here is the full Measure:
//This variable needs to be converted to a constant value.
VAR Variable1 = CALCULATE( sumx(maintable, maintable[Value]), Filter(All(maintable[position]), maintable[position] = 1), maintable[intensity]=0 )
RETURN
//The VAR from above is plugged into the measure below. When Variable1 is instead hardcoded with the same fixed/contant value the measure works perfectly. Is there a workaround?
if(or(SUM(maintable[position]) = 0 && sum(maintable[Value]) = Variable1,
(SUM(maintable[intensity]) = 0 && sum(maintable[Value]]) = Variable1)),
Sum(maintable[Value]) +1, Sum(maintable[Value]))
Community SupportHi roncruiser ,
Modify your variable as below:
Variable1 =
SUMX (
FILTER (
ALL (maintable[position],maintable[intensity]),
maintable[position] = 1
&& maintable[intensity] = 0
),
maintable[Value]
)
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
- roncruiser
Thank You.