Nested Measure

[ttaa4455]

Hello, 

I have the following measure set and it function as I went it to : 

VAR DistinctProds = 

SUMMARIZE(Monthly_Measure,Products[Products_ID],Stores[Store_ID]

VAR Prod=

Countrows(Distinct Prods)

Return

Prod. 

But the issue I have is that a have another column in the 'Monthly_Measure' Table called Quanity_Cases and I need that measure I showed above to filter out any rows that have a Quanity_Case of 0 or less. How can I do that? 

Thank you!!

[tamerj1 · Accepted solution]

Hi @ttaa4455 
Please try

=
VAR DistinctProds =
    SUMMARIZE (
        FILTER ( Monthly_Measure, Monthly_Measure[Quanity_Cases] > 0 ),
        Products[Products_ID],
        Stores[Store_ID]
    )
VAR Prod =
    COUNTROWS ( DistinctProds )
RETURN
    Prod

[ttaa4455]

Thank you!! That worked!