Filter countx of a measure

[Anonymous]

I used the following measure 

MEASURE Capacity_Share = CALCULATE(100 * DIVIDE(SUM('19981201 Victoria'[Wind -  GWh]),'19981201 Victoria'[MEASURE_PowerBiComm]))

to plot the following bar chart.

bar chart

Next to the bar chart I am trying to show a table with the months that are < 60.

With the following measure

MEASURE Quiet_Months = COUNTX(VALUES('19981201 Victoria'[date]),[MEASURE Capacity_Share])

I get

Table 

But how do I filter count for measure < 60?

[tamerj1]

Hi @Anonymous 

please use 

MEASUR Quiet_Months =
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            VALUES ( '19981201 Victoria'[date] ),
            "@Capacity", [MEASURE Capacity_Share]
        ),
        [&Capacity] < 60
    )
)

[Anonymous]

Hello, @tamerj1 

Your solution has not worked.

DAX does not acknowledge [&Capacity]. 

[&Capacity] not acknowledged

If I replace it with [MEASURE Capacity_Share], the result is 

wrong results

when it should be

Correct result

Cheers

[tamerj1 · Accepted solution]

@Anonymous 
Sorry that was a typo mistake

MEASUR Quiet_Months =
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            VALUES ( '19981201 Victoria'[date] ),
            "@Capacity", [MEASURE Capacity_Share]
        ),
        [@Capacity] < 60
    )
)

[Anonymous]

Hello, @tamerj1 

I have fixed it

fixed code

but it's still not working

Wrong results

[tamerj1]

@Anonymous 

Would you please share the code of [MEASURE Capacity_Share]?

[Anonymous]

MEASURE Capacity_Share = CALCULATE(100 * DIVIDE(SUM('19981201 Victoria'[Wind -  GWh]),'19981201 Victoria'[MEASURE_PowerBiComm]))


MEASURE_PowerBiComm = CALCULATE(MAX('19981201 Victoria'[Wind -  GWh]),'19981201 Victoria'[date] <= MAX('19981201 Victoria'[date]))

[tamerj1]

Thank you @Anonymous 

Would you please add the date to the matrix row heirarchy and see what results you get for [MEASURE Capacity_Share] Measure? Otherwise can we zoom connect for beeter assessment?

[Anonymous]

Hello, @tamerj1 

I started the chart from scratch using different data and, lo and behold, your formula worked fine. Cheers

countrows of a measure