total records per condition in matrix

[Anonymous]

Hello, I have a matrix visual with data from 2 data tables.  It is a list of names (1st table), and how many contact occurences per name (2nd table).  The reason for 2 data sources is that 2nd source is only results, some Names will not have results, and I need to show a comprehensive list of names to show (1st source)

I need a summary visual or card showing me how many names have atleast 1 contact occurence and how many names have 0 contact occurences.  Any help would be much appreciated, and thanks in advance!!

Name	Phone	Email	Mail	Total
Dan				0
Jim	1	1		2
Jeff	3		1	4
Tim				0
Jack	1		1	2
Shawn				0
Total	5	1	2	8

[amitchandak]

@Anonymous , first create a measure assuming table1 name is used in visual

cnt = Countrows(filter(Table2, Table2[Name] = max(Table1[Name]) ) )

Now create a table of using generate series

Seg = generateseries(1,10,1)

Then have measure

Sumx(Seg, calculate(Sumx(filter(Values(Table1[Name]), [cnt] = Max(Seg[Value]) ) ) ) )

Refer

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

[Anonymous]

Hello, my apologies but am having problems with the solution you proposed.  The situation has changed slightly - I have a matrix listing hundreds of company names, there is one value field with either numbers or no data.  I need a card (or metric to put in the card) that shows me % of companies with atleast 1 in the value field.  The goal is to show the % of companies that have participated, in the following example, the card / metric would show 50%, or 4 of 8.

Company	Value
A
B	1
C	3
D
E	6
F
G
H	2