Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX For Weighted Column

Hello, I am looking to create a weighted calculation of data quality in the organization.   The data consits of the following columns: Application Data Quality Attribute Data Subject Area Busin...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    I believe this is the result you want.  You may download my PBI file from here.

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Sorry for the delay in replying.  I just saw your post.  I downloaded the file but am unable to understand your expected result.  Please let me know the exact answer/output you are expecting.  Thank you.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Ashish_Mathur Let me try this again.

 

This is a data quality dashboard. Where I have a Source Column Dimension. Each source column belongs to a data subject area i.e. Account, Customer etc.

 

When I am looking at Data Subject Area for a particular CRM(Application) i.e. App1, App2. I have the total number of customers, and total number of accounts in the Source Entity Key Column. In this case those values are 5K and 100K respectively.

 

I want to calculate the total customer % as a % of the total records. i.e. 5000/(5000+100000) and 100000/(5000+100000). These calculations need to filterable by the Application and Data Subject Area Column.

 

 

Is this the info you need?