DAX : Divide based on the selection of filtered

[Joelraj08]

Hi all,

Good day!

please see the screenshot below.

In table 2, calculate based on table 1.

Department AB 310/1211 for C

dept. AB 336/1211 for B

dept. AB 565/1211 for A

If I filter the A, B, and C columns, then it comes up with

1211/1948 = 62.17% 

My ask is instead of this above calculation, If i filter A, then it should calculate with department dept. AB 565/1211 for A.

If it's possible, please help.

Thanks in advance!

[Joelraj08 · Accepted solution]

Solution : 

% OF ABC = CALCULATE(COUNT('Column'[ID]),'Column'[Remarks]=SELECTEDVALUE('Column'[Remarks]))/CALCULATE(COUNT('Column'[ID]),ALLEXCEPT('Column','Column'[Business  Line]))