Forum Discussion

Copper Contributor

Sep 17, 2022

DAX: Count the weeks where price is over $18

Hi, all. I have a power pivot where I'd like to count the number of weeks where average price exceeded $18. Any help would be greatly appreciated.

Silver Contributor

Sep 18, 2022

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)")
)