Forum Discussion
DAX For Weighted Column
Hi,
I cannot understand your question. Share the data and expected result.
Ashish_Mathur If you look in the same data set used in your solution, every row has a Source Key Count attatched to it. For Account the value is 100K and for Customer it is 5K. I need the total to be 105K and it need to be filterable by Application column.
To simplify I am looking for the total number of sourcekeys per application. The issue is we have many rows per Data Subject Area(Account & Customer) per application.
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.
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?
Ashish_Mathur I added this as a seperate problem to avoid confusion, can you please have a look at it.
https://community.powerbi.com/t5/Desktop/Sum-of-Distinct-Values/m-p/539037#M253079