Conditional Count of Multi Columns with Filters

[hamadani]

Hello,

I have a table with the following 5 columns: 

Customer ID	Loan 1	Loan 2	Loan 3	Loan 4
Cust1	A	D
Cust2	B	A	C	D
Cust3	D
Cust4	B	A	D

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

[amitchandak · Accepted solution]

@hamadani , Unpivot the 4 columns Loan1 -4 and then try to use the filter

https://radacad.com/pivot-and-unpivot-with-power-bi