How to properly count the "Y"?

[ChadGalicia]

Dear Experts,

I have a measure to compute for the variance of cost/unit of current from the previous cost/unit.

The problem that I encounter is the count card doesn't reflect the correct numbers based on the table.

Here's the dax that I wrote Count of Y = COUNTAX(KE30,KE30[limit reached?]="Y")

I tried different approaches which can be found also in the pbix file but the dax returns error.

I have attached the image and also the pbix for your reference.

here's the pbix file

Your help is much appreciated.

Thank you.

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached my PBI file.

Hope this helps.

[ChadGalicia · Accepted solution]

@Ashish_Mathur Thanks for your dax somehow I was able to revise your code and make it work somehow.

1 Count of Y =

COUNTROWS(

    FILTER(

        SUMMARIZE(

            GENERATE('Calendar', KE30),

            'Calendar'[Date],

            KE30[Product Code],

            KE30[Plant Code],

            "ABCD", [limit reached?]

        ),

        [ABCD] = "Y"

    )

)

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached my PBI file.

Hope this helps.

[ChadGalicia]

Thank you so much for this.

I can see that it counted the unique product codes but, currently, the goal is to count the occurrence of Y.