Forum Discussion

PVO3's avatar
PVO3
Impactful Individual
4 years ago

Multiple contexts within iterator

Hello all,   I would like some help with a measure. See the screenshot below. I would like that the result of Measure2 would be 143 for every row. In VAR _Result I already have the result and the...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

PVO3 , try like

 

 

Measure2 = 
VAR _MaxR = CALCULATE(MAXX(VALUES('Date'[Month Year]),[Measure1]),allselected())
VAR _Avg = DIVIDE(CALCULATE(SUMX(VALUES('Date'[Month Year]),[Measure1]),allselected()),_MaxR)
VAR _Result = power(([Measure1] - _Avg)  ,2)
RETURN

IF(
    [Measure1] < 1,BLANK(),
    _Result 
)

 

 

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

PVO3's avatar
PVO3
Impactful Individual
4 years ago

Thanks!

I changed the REMOVEFILTERS to ALLSELECTED & ^2 to POWER(,2)

Unfortunatly the result remained the same. 

 

But perhapse this is an improvement in general.

 

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    PVO3 , Please share sample in table format , need to try this in power bi

    • PVO3's avatar
      PVO3
      Impactful Individual
      4 years ago

      Thanks a lot for your effort.

      I created an example. Link in first post.