Forum Discussion

MVaughan1's avatar
MVaughan1
Frequent Visitor
8 years ago
Solved

Dynamically changing assumptionss from Report view

Hello, I am trying to find a way of displaying assumptions that can be changed in the Report view.   I cannot share my data for confidentiality, but here is a representative sample of the data   ...
  • MVaughan1's avatar
    MVaughan1
    8 years ago

    Hi kohlivinayak,

     

    I have got this to work, not because of the decimal but because my formula was in a calculated column rather than a measure.  

     

    The Selected Value and IF HAS ONE VALUE functions both seem to rely on measures.   Not sure if this is basic Power BI chapter 1 that I skipped over but certainly a key learning point for me.       What is a bit of a pain is that it seems as though I will have to convert all my existing columns into measures.  I got this to work by changing my vs PY to a "SUM vs PY" measure..     I don't really understand why this is needed, but I shouldn't take any more of your time on this.

     

    Thanks once again,  really appreciate your help.

     

    Mark

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi MVaughan1,

 

"Is Actual Revenue(B) within 10% (Tolerance) of Forecast Revenue (C) and Last Year Revenue (D)"

<--- Could you clarify more details about your logic and expected result?

 

Regards,

Jimmy Tao