Forum Discussion
DAX For Weighted Column
Ashish_Mathur Can you answer another query for me.
If i wanted to calculate the sum of source keys for all data subject areas. How would that be done? This needs to be filterable by Application only.
Account 100000
Customer 5000
Total = 105000 (Expected Ans)
Super UserHi,
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.
- Ashish_Mathur
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?