Subtotaling defined measures in summarize

[pbiKrystian]

Hi, 

I'm trying to create subtotal to week level in dax query using defined measure, but it always just shows 1. Here is an example of code, which might explain what I'm trying to achieve:  

DEFINE
    MEASURE 'Sales'[factor] =
        CALCULATE (
            IF (
                [Total Sales] > 0, 
                1,
                0
            )
        )
        
EVALUATE
    SUMMARIZE (
        CROSSJOIN (
            FILTER ( 'Date', 'Date'[WeekDayNumber] <> 7 && 'Date'[Date] < TODAY () && 'Date'[ISOWeek] = 40 ),
            'Store'
        ),
        'Store'[Store Code],
        'Date'[Year],
        'Date'[MonthNo.],
        'Date'[ISOWeek],
        'Date'[Date],
        "Sales", [Total Sales],
        "factor", [factor], 
        "weeklyFactory", CALCULATE('Sales'[Factor], ALLSELECTED('Date'[ISOWeek])
    )

Thanks for help, 

Krystian

[amitchandak]

@pbiKrystian , for subtotal you can create a week column in you date table and use allexpect

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/