Distinct Count of Blank Lines

[aadelacr]

Hey Everyone, i am essentially needing a distinct count of all the lines below (displayed in the left) to be reflected in the card to the right. I need a calculation to look at a distinct count of all items which have a blank in order quantity (disregard the placeholder coulumn). I essentially need the Count of Desc column of 140 to be reflected in the card to the right.

My table names are Articles (i am using Desc in this table), Purchase History ( I am using Order Quantity in this table)

[v-jiewu-msft]

Hi @aadelacr ,

If I understand correctly, the issue is that you don’t know how to display the selection in the details page. Please try the following methods and check if they can solve your problem:

1.Create the simple tables.

2.Click on Modeling in the top menu, then click on New Measure.

3.Enter the following DAX formula for the measure:

Articles_without_orders =
CALCULATE (
    DISTINCTCOUNT ( Articles[Desc] ),
    FILTER ( 'Purchase History', ISBLANK ( 'Purchase History'[Order Quantity] ) )
)

4.Add the measure to a card visual to display the distinct count of blank lines.

If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format to make a deep troubleshooting? It would be helpful to find out the solution.

Looking forward to your replay.

Best Regards,

Wisdom Wu

[aadelacr]

Still recieving a "blank" when inserting it into the card. 

Sample data:

Articles Table

Item	Item Desc
a	Chair
b	Stool
c	Gloves
d	Box Cutter
e	Latter

Purchase History

Order #	Item #	Item Desc	Order Quant
12345	a	Chair	100
11223	a	Chair	150
11234	b	Stool	300
99564	c	Gloves	60
45013	c	Gloves	30

I have a many to one relationship where the "Articles" table filters "Purchase History"