DAX: Count the weeks where price is over $18

Paul_Cracknell 

If you want your filtering value in a cell like in E3 below:

in F3:

=CUBESETCOUNT(
    CUBESET("ThisWorkbookDataModel",
        "(
            FILTER(
                [Table1].[Week].Children,
                [Measures].[Avg Price] > " & E3 & "
            )
        )"
    )
)

Paul_Cracknell 

Assuming data in Table1 and the average measure is named Avg Price

in E3:

=CUBESETCOUNT(
    CUBESET("ThisWorkbookDataModel", "FILTER([Table1].[Week].Children, [Measures].[Avg Price] > 18)")
)