Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Help with Dax.

Hello All, I need help with a DAX formula (or using variables) to solve a data quality scoring issue. Here's the situation: I have a static table called "Parent Table" that contains: Table Name...
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi Anonymous ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you burakkaragoz for the prompt response.

    I have tried replicating the scenario using sample data.Please go through the attached PBIX file for your reference.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

    Thank you.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

I have tried all the solution provided by Chatgpt and Copilot. It give me the error 

"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

Anonymous's avatar
Anonymous
Not applicable
1 year ago

The mapped table contains unique values created through merge queries in Mquery.

Requirement: When the average quality score is 92.30% (highlighted in pink) and does not meet the threshold, it should be flagged for debugging. The threshold indicator should be red instead of green.