Card - count

Question

Hi All&nbsp;Thanks in advance for the help.&nbsp;I am trying to create cards that shows number of customers that is meeting Sales Target as well count that is not meeting the target.&nbsp;See sample table below which detailed customer by product with the sales, target and the variance between them.&nbsp;CustomerProductSalesTargetVarianceCustomer APROD A&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50Customer BPROD A&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300-$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100Customer CPROD A&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 350&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 320&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30Customer DPROD A&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100Customer EPROD A&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 350-$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150Customer FPROD A&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 450-$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50Customer APROD B&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150-$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50Customer BPROD B&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100Customer CPROD B&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 350&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 320&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30Customer DPROD B&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400-$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100Customer EPROD B&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 360&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 350&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10Customer FPROD B&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 450&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50Now:-(a) I have one customer that is not meeting sales target overall(b) I have 3 customers that is not meeting target for PROD A(c)&nbsp;I have&nbsp; customers that is not meeting target for PROD B&nbsp;I have slicers of Customer and Product&nbsp;How do i dynamically display cards that shows the count of customers that is not meeting target.&nbsp;I tried creating additional tables which shows the distinctcount by customers only where variance is less than 0. This didn't work when i add product as part of my slicer. If i include product in the additional table, the count will be off.&nbsp;is there a way to achieve this as i am in the midst of miragting from Oracle BDD. BDD has a feature that shows summarization bar which show dimension values that exceed&nbsp;a threshold.&nbsp;Any help is much appreaciated.&nbsp;regardsdeven

v-lili6-msft · Accepted Answer

hi,&nbsp;dkrishnan
After my test, you could try this way:
measure = CALCULATE(SUM(Table1[Variance] ))
Result = 
VAR _table =
    SUMMARIZE ( Table1, Table1[Customer], "var", [measure] )
RETURN
    IF (
        HASONEVALUE ( Table1[Product] ),
        CALCULATE ( COUNTA ( Table1[Customer] ), FILTER ( Table1, [measure] &lt; 0 ) ),
        CALCULATE ( COUNTAX ( FILTER ( _table, [var] &lt; 0 ), [Customer] ) )
    )
Result:

&nbsp;
here is pbix file, please try it.
&nbsp;
Best Regards,
Lin
&nbsp;
&nbsp;
&nbsp;

Customer	Product	Sales	Target	Variance
Customer A	PROD A	$ 100	$ 50	$ 50
Customer B	PROD A	$ 200	$ 300	-$ 100
Customer C	PROD A	$ 350	$ 320	$ 30
Customer D	PROD A	$ 500	$ 400	$ 100
Customer E	PROD A	$ 200	$ 350	-$ 150
Customer F	PROD A	$ 400	$ 450	-$ 50
Customer A	PROD B	$ 100	$ 150	-$ 50
Customer B	PROD B	$ 400	$ 300	$ 100
Customer C	PROD B	$ 350	$ 320	$ 30
Customer D	PROD B	$ 300	$ 400	-$ 100
Customer E	PROD B	$ 360	$ 350	$ 10
Customer F	PROD B	$ 500	$ 450	$ 50

Forum Discussion

Card - count

2 Replies

Related content

Counting nulls

MULTIPLE CARD

Ranking KPI card

Card Visual

Where is the Multi-row card