Hi all,
Not sure if you can help me here and this might take a moment to explains. A sample of my data set is as follow:
<tbody>
</tbody>
I'm looking at cross sales. In the example above Paul Simon has two products. I need to create a measure which will give me:
NO FILTER
<tbody>
</tbody>
FILTER ON AUDIT
<tbody>
</tbody>
FILTER ON TAX
<tbody>
</tbody>
I basically need to see the revenue amount for the client irrespective of the filter. If I select Tax it should give me all clients with revenue for Tax and then the Revenue for the other business lines.
Happy to elaborate more if necessary. This is causing me a lot of pain. I've currently created calculated columns but this is causing performance issues and I'll like to see if I can do this with measures instead.
If I use calculate with (Filter = Audit) then it will continue to show the record for Bob Jones when I filter for Tax where in reality I only want the Revenue amount if there is a value for Audit AND a value for Tax.
Any help would be appreciated! Thanks all
Not sure if you can help me here and this might take a moment to explains. A sample of my data set is as follow:
Client | Business Line | Revenue |
Bob Jones | Audit | $100,000 |
Paul Simon | Tax | $100,000 |
Paul Simon | Audit | $100,000 |
<tbody>
</tbody>
I'm looking at cross sales. In the example above Paul Simon has two products. I need to create a measure which will give me:
NO FILTER
Client | Audit | Tax | |
Bob Jones | $100,000 | ||
Paul Simon | $100,000 | $100,000 |
<tbody>
</tbody>
FILTER ON AUDIT
Client | Audit | Tax |
Bob Jones | $100,000 | |
Paul Simon | $100,000 | $100,000 |
<tbody>
</tbody>
FILTER ON TAX
Client | Audit | Tax |
Paul Simon | $100,000 | $100,000 |
<tbody>
</tbody>
I basically need to see the revenue amount for the client irrespective of the filter. If I select Tax it should give me all clients with revenue for Tax and then the Revenue for the other business lines.
Happy to elaborate more if necessary. This is causing me a lot of pain. I've currently created calculated columns but this is causing performance issues and I'll like to see if I can do this with measures instead.
If I use calculate with (Filter = Audit) then it will continue to show the record for Bob Jones when I filter for Tax where in reality I only want the Revenue amount if there is a value for Audit AND a value for Tax.
Any help would be appreciated! Thanks all