Forum Discussion
Performance inspector for Desktop?
parry2k i hear what you're saying but i am not sure it is the right solution for my problem. let me explain my situation in greater detail:
I have a table with 20k rows and about 30 columns. Each row is a customer. One column holds a contract code, which relates to another table. Each other column represents the revenue transacted by that customer in a particular category of products.
I have another table that holds the contract information. For additional context, multiple customers can be on a contract - think of it like group purchasing. Each row in that table is a contract code and each column represents whether our not they are contracted in a particular category of products.
I want to join those two because I need to calculate compliance to the contract on a customer level. To put ths into context, at each customer there are several purchasers. I want to calculate the $ per purchaser and then compare that to a benchmark value that I have in another table.
Ultimatley, I have no idea how to perform all those operations in DAX because they need to be perform on a line-by-line basis
Anonymous I believe it can be achieved using DAX, may be best would be to send sample data (hide any sensitive inforamtion) and what you want to achieve and will try to get you the solution.