No of rows in a table visual

[Anonymous]

Is there any way to display No of Rows returned/displayed in a TABLE visual? 

Currently I have a table displaying Sales persons who have multiple sales in a month (Showing person name, number of sales). Say there are 23 Sales persons listed (i.e 23 rows in the table). Any easy way to display 23 in a KPI or card visual without writing a complex DAX query? If that can not be done, someone can help me with a query? This is similar to writing a select count(*) on a given SQL query, which is not easy in DAX.

Hope this makes sense.

[Vvelarde · Accepted solution]

hi @Anonymous

Use this and try it

Number-Persons =
COUNTROWS (
    FILTER (
        SUMMARIZE (
            Sales;
            Sales[Person];
            "NumberofSales"; CALCULATE ( COUNTA ( Sales[Person] ) )
        );
        [NumberofSales] > 1
    )
)

[Anonymous]

@Vvelarde Thank you very much. Though not in the exact syntax, it points to the right direction. 

this is the one.

COUNTROWS (
filter(SUMMARIZE (
'Sales',[Sales Person],
"Number Count", 'Sales'[Sales Row Total]), [Number Count]>1)
)

[SamLester]

@Anonymous, you can also use a Card visual to display this. Just drag SalesPerson into a Card visual and the count will be displayed. You can also use Count(Distinct) if you want that value.

Thanks,
Sam Lester (MSFT)

[Anonymous]

@ankitpatira@SamLester I already tried that before. I was using a distinct count on the Sales person (this is a sales table), it gave me the No of Sales person including the ones with only 1 sale. In the table visual, I can easily use a number of sales > 1 visual level filter. But I cannot use the same filter at the KPI (or card) visual. Please try it and you know what I mean. 

[jahida]

Bit late but I think a simple measure would do the trick. Something like

COUNTROWS(FILTER(SalesPeople, SalesPeople[Sales] > 1))

You could then throw that onto a card and it should give you the number you want.

EDIT: My bad, misunderstood the information held in the table. See below for a better answer.

[ankitpatira]

@Anonymous you simply need to drop Sales Person field from your table into KPI visual.