Forum Discussion

hamadani's avatar
hamadani
Frequent Visitor
4 years ago
Solved

Conditional Count of Multi Columns with Filters

Hello,

 

I have a table with the following 5 columns: 

 

Customer IDLoan 1Loan 2Loan 3Loan 4
Cust1AD  
Cust2BACD
Cust3D   
Cust4BAD 

 

I have a slicer filter for the Loan where I can choose from the exisiting loans (A, B, C, D)

 

What I want to do is to show the total number of customers who have taken a particular loan (based on the slicer selection filter). For instance, if the user chooses Loan A from the filter, the card shows 3 or if the user chooses C, the card shows 1

 

Any help would be appreciated