Count of a measure

[Justas4478]

Hi, 
I have this measure:

Shorted = 'Outbound Delivery'[Total Demand] - 'Outbound Delivery'[Total Actual]
It calculates difference between ordered and actual resulting in amount not fufilled.
I am trying to create other measure that counts how many 'Shorted' there are per day.
That is measure I tried:

Shorted times count = COUNTAX('Outbound Delivery','Outbound Delivery'[Shorted])
This is result I got but what I expected to get is in red:

Let me know if there are any questions.

Thanks

[_AAndrade]

Try this measure:

CALCULATE(
    COUNT(T_OutboundDelivery[Shorted]),
    T_OutboundDelivery[Shorted] <> 0
)

The final result would be this:

[Justas4478]

@_AAndrade Hi, I am using measures since it is company controlled live connection model.
That is only thing I am able to create.
This is what I have in 'Outbound Delivery' table.
I created 'Shorted' measure using 'Total Demand' and 'Total Actual' measures.
But there are 'Demand' and 'Actual' hidden columns that would need to be summarised.

Idealy I would like the solution to work with the measures if possible.

[_AAndrade · Accepted solution]

Hi @Justas4478,

I'm using this data set:

And this is my measures:

Total Actual = SUM(T_Outbound[Actual]) 

Total Demand = SUM(T_Outbound[Demand]) 

Shorted = [Total Demand] - [Total Actual]

Count Shorted = 
VAR _Table = 
    SUMMARIZE(
         T_Outbound, 
         T_Outbound[Level 2],
         T_Outbound[Date],
         "@Shorted", [Shorted]
    )
VAR _Result =
    COUNTX(
        FILTER(
             _Table,
              [@Shorted] <> 0
        ),
        [@Shorted]
    )
RETURN
  _Result

The output is:

I hope this could solve your problem.

[Justas4478]

@_AAndrade Hi, I have been using solution that you provided.
And it is great, there are only case when shorted qty is 0 it returns rezult blank when I would expect to return 0.
I tried to change  <> to >= in the measure but that only change from this:

 
to this:

I am not sure which part I need to modify so the 1's that have shorted qty of 0 would return 0.
Thanks

[Justas4478]

@_AAndrade I think I manage to find the solution I added +0 to this part of the dax.

VAR _Result =
    COUNTX(
        FILTER(
             _Table,
              [@Shorted] <> 0
        ),
        [@Shorted]
    )+0
RETURN
  _Result

Let me know if you think there is better way.
This is the result:

[_AAndrade]

Great news.

[Justas4478]

@_AAndrade It looks like it is working without any problems so far.
Thank you for the help.

[_AAndrade]

Great.You're welcome.

[_AAndrade]

Hi @Justas4478,

You are using calculated columns, right?