Forum Discussion

NJ81858's avatar
NJ81858
Icon for Helper IV rankHelper 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
NJ81858's avatar
NJ81858
Icon for Helper IV rankHelper 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
Icon for Memorable Member rankMemorable 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
    Icon for Helper IV rankHelper 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.