Table keeps crashing when i put multiple measures in there

[Powerbi12399]

Hi all,

i created some measures, screening, interviewing, and offer etc. I've been changing the code of interviewing to avoid the error like the screenshot below. but i am just not able to avoid, is it a but of the system or it's something wrong in my code?😭

[Powerbi12399]

hi thank you so much for replying, so i created another table to do all the measures, and it worked

[v-ssriganesh]

Hello @Powerbi12399,
Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.
Please don’t forget to “Accept as Solution” and Give “Kudos” if the response was helpful.
Thank you.

[v-ssriganesh]

Hello @Powerbi12399,

Could you please confirm if your query have been resolved? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

Thank you.

[Powerbi12399]

Even for my funnel visual is the same issue

if i put more than 2 measure to this visual is would become like this above.

Here are my code for the measures:

[v-ssriganesh · Accepted solution]

Hi @Powerbi12399,
Thank you for reaching out to the Microsoft fabric community forum.

Based on the error message "An unexpected exception occurred," this behavior is likely related to model or visual complexity rather than a bug in your DAX itself.

Here are a few things you can check to isolate and resolve the issue:

• When using CALCULATE(COUNTROWS(...), FILTER(...)), ensure your Candidates table isn't being referenced multiple times in a way that causes context confusion and from your latest version using VAR ValidApplicants = FILTER(...), confirm that the Requisition # column isn’t causing ambiguity across relationships.

• Start with only the Screening measure on the visual if that works, add Interviewing, then Offer.
• If the crash happens only when multiple are added, consider combining related logic into a single measure using SWITCH() or use a matrix visual with Status Type as a row.

• Sometimes visuals crash when certain filters are not applied. Wrap your measure logic with IF(HASONEVALUE(Candidates[Status Type]), ..., BLANK()) to prevent errors when context is missing.

Consider switching the card or funnel visual temporarily to a table or matrix, which are more stable for debugging.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[v-ssriganesh]

Hi @Powerbi12399,
I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.
If your question has been answered, please “Accept as Solution” and Give “Kudos” so others with similar issues can easily find the resolution.
Thank you.