Forum Discussion

NJ81858's avatar
NJ81858
Helper IV
3 years ago

User Entered Value Across All Pages

Hello,   I have a report that is contingent on users entering in a value for all of my calculations. What is the best way to achieve this? It has to span multiple pages and I would prefer the user ...
Need Help
pratyashasamal's avatar
pratyashasamal
Memorable Member
3 years ago

Hi NJ81858 ,
Try to check if all the what if Parameter are having the correct data type i.e. Numeric data type.
Looks like issue is due to this.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

NJ81858's avatar
NJ81858
Helper IV
3 years ago

pratyashasamal  The value is currently a number, but it still gives me that error that it is text:

 

  • pratyashasamal's avatar
    pratyashasamal
    Memorable Member
    3 years ago

    Hi NJ81858 ,
    This issue probably because you have empty strings there, you can check for the blanks or empty strings first .
    You can use ISBLANK() for this.
    https://learn.microsoft.com/en-us/dax/isblank-function-dax

    Thanks,
    Pratyasha Samal
    Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
    If you found this post helpful, please give Kudos C

    • NJ81858's avatar
      NJ81858
      Helper IV
      3 years ago

      pratyashasamal After doing more research, I am unable to use What-If parameters for my solution, as Calculated Columns don't support the use of What-If parameters.