Forum Discussion
Variance by Contracts
Variance by Customer Name: I have listing of contracts that are tied to 2% rebates. The Matrix I have "Variance by Customer Name" shows variances. Variance is calculated this way: Forecated Reve...
amitchandak
Super User
Super UserAnonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Amit, I have created new DAX measure, which is not excluding contract that have rebate.
Current measure: Variance Forecasted - Recognized I = [Recognized Revenue I] - [Forecasted Revenue]. Which is including all contracts.
New measure:
Variance Rebates = CALCULATE(
[Variance Forecasted - Recognized I],
(ALLEXCEPT('Reference - Rebates','Reference - Rebates'[Number])
))
The issue is it's not filtering out the contract that have rebate tied to it.