Forum Discussion
Calculation change with drill down
Hi Community,
I have to calculate percentage of principal outstanding at state and branch level but my denominator will change for State and Branch.
My dax is not behaving correctly for State as I drill up. it is keeping denominator of branchname.
For example:
| Loan No | State | BranchName | POS |
| 1 | Rajasthan | Jaipur | 2 |
| 2 | Maharashtra | Nasik | 5 |
| 3 | MP | Indore | 1 |
| 4 | Rajasthan | Jaipur | 7 |
| 5 | Maharashtra | Nasik | 3 |
| 6 | Rajasthan | Jaipur | 1 |
| 7 | Rajasthan | jaiselmer | 3 |
| 8 | Maharashtra | nagpur | 1 |
| 9 | MP | Indore | 2 |
| 10 | MP | bhopal | 2 |
My DAX is:
IF(HASONEVALUE('Summarized MIS'[State]),'Summarized MIS'[POS]/CALCULATE(SUM('Summarized MIS'[POS]), ALLEXCEPT('Summarized MIS','Summarized MIS'[State])),'Summarized MIS'[POS]/CALCULATE(SUM('Summarized MIS'[POS]), ALLEXCEPT('Summarized MIS','Summarized MIS'[BranchName])))
it is working for BranchName but not for State.
the value should change dynamically as I drill up or drill down.
15 Replies
I have been stuck at this problem for a very long time and it is highly important for me to find a solution. Any help would be appreciated.
Thanks in advance!
yes.
Measure is throwing a different result altogether.
