Forum Discussion

GJD23's avatar
GJD23
Frequent Visitor
1 year ago

Error fetching Data for this visual - Visual not displaying

Hi , I see similar issues where error is on SErvice and not desktop - we are the other way round Our compnay don't do monthly updates but we have just updated from April24 to Oct 24 and a number o...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi GJD23 

 

Thank you very much dk_dk for your prompt reply.

 

I tested it under the same version and did not experience the same issues as you.

 

 

%age Of ReqsAllowing Full LT = 
var HasReq_dLT = SUM('Table'[HasReq])
var NOTReq_dLT = SUM('Table'[NOT Req])
RETURN
IF(
    (HasReq_dLT + NOTReq_dLT) = 0,
    0,  
    DIVIDE(HasReq_dLT, HasReq_dLT + NOTReq_dLT)
)

 

 

Measure = DIVIDE('Table'[HasReq'dLT], 'Table'[HasReq'dLT] + 'Table'[NOT Req'dLT], 0)

 

 

Try adding [HasReq'dLT]+[NOT Req'dLT] to the card to see if an error occurs.

 

Please provide sample data that fully covers your issue and the expected outcome based on the sample data you provided.

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.