Counting Rows basis of two columns

Question

I have data like below&nbsp;Vendor codeDuplicate basis of Bank accountDuplicate basis of name&nbsp;Duplicate basis of AddressVendor A111Vendor B110Vendor C100Vendor D001Vendor E101&nbsp;I am trying to create table visual as below but I am stuck for the vendor where more than one condition is true.&nbsp;KPIsCountPercentageCount of duplicate vendor basis on Bank account&nbsp;480%Count of duplicate vendor basis on name&nbsp;240%Count of duplicate vendor Address&nbsp;360%&nbsp;Above table is just illustration of real table.&nbsp;Can any one help????

jaideepnema · Accepted Answer

Hi&nbsp;Jagriti11&nbsp;,Unpivot the columns excluding the vendor code and then create two measures for Percentage and Vendor Count&nbsp; as shown below:Vendor Count = CALCULATE(DISTINCTCOUNTNOBLANK(Data[Vendor code]),Data[Count]=1)Percentage % = DIVIDE([Vendor Count],CALCULATE([Vendor Count],ALL(Data[Flag])),BLANK())This will give you desired result:&nbsp;&nbsp;Please accept this as a solution if you question has been answeredAppreciate a Kudos&nbsp;😀&nbsp;

Forum Discussion

Counting Rows basis of two columns

1 Reply

Related content

count basis date

Total Count in Column

Counting nulls

Column count duplicates

Count base from other column

Vendor code	Duplicate basis of Bank account	Duplicate basis of name	Duplicate basis of Address
Vendor A	1	1	1
Vendor B	1	1	0
Vendor C	1	0	0
Vendor D	0	0	1
Vendor E	1	0	1

KPIs	Count	Percentage
Count of duplicate vendor basis on Bank account	4	80%
Count of duplicate vendor basis on name	2	40%
Count of duplicate vendor Address	3	60%