Forum Discussion
Help on DAX
Hi All, Need help pls..
If you see in Dax, I've inserted measures in 1st IF condition, checking that if they blank then measure[Total Work]*480 or else any of the measures fill up with any value in 1st IF condition then [Total work] devide by [Proc FTE Available Hours] which is there always. Dont understand the above error.. pls pls guide
Hi PowerBIBeginer ,
Try to Use ISBLANK() in the if statement in place of = " "
For example :-
ISBLANK([EDP])
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
7 Replies
Hi PowerBIBeginer ,
Check if column [Total Work] or [Proc FTE Available Hours] column is having the correct datatype (It should be numeric data type) . This error usually occurs if there is incorrect datatype (text) being used in calculation .
Hope this was helpful.
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 CHi, Thanks for your reply. Appriciate your time. Total work and Proc FTE Available Hours they both are measures and kept data type as whole number.
I even tried this but same error..
Proc Prod = IF((VALUE([Lost Account]="" || [EDP]="" || [3rd party]="" || [Naming]="" || [Canceled]=""), ([Total Work]/480), IFERROR([Total Work]/[Proc FTE Available Hours],""))try to check if all the columns in the if check statement are text data type
Hi Pratyasha, Thank You so much for your valuable time and efforts for understanding my issue.
Appriciated it!!
It works now..
