No totals and wow wrong

[ROG]

Hi folks!

Can you please help me figure it out, why the total from 'Previous Week Net' isn't showing? 
Also, why the week 34 doesn't have value on the 1st column and -100% on the others?

See below the measures.

CurrentWeek Net= SUM( Net)

PW Net Churn =

VAR PriorWeek = SELECTEDVALUE ( '🔎Calendar'[Week Number Year] ) -1

RETURN

CALCULATE(

    [Net Churn - 30D],

    ALL ( '🔎Calendar'[Week Number Year]),

    '🔎Calendar'[Week Number Year] = PriorWeek

)

 

Net Churn% WoW = ([CurrentWeek Net]-[PW Net Churn])/[PW Net Churn]

Net Churn % WoW Change = [Net%] - [Net Churn% WoW]

Thanks

[memepu · Accepted solution]

Hi @ROG ,

Create three measures based on  the above  measures.

CurrentWeek Net total=var _b=SUMMARIZE('calendar','calendar'[date],"aaa",'calendar'[CurrentWeek Net])
return
IF(isinscope('calendar'[date]),'calendar'[CurrentWeek Net],SUMX(_b,[aaa]))

Net Churn% WoW total =var _b=SUMMARIZE('calendar','calendar'[date],"aaa",'calendar'[Net Churn% WoW])
return
IF(isinscope('calendar'[date]),'calendar'[CurrentWeek Net]Net Churn% WoW],SUMX(_b,[aaa]))

Net Churn % WoW Change total= var _b=SUMMARIZE('calendar','calendar'[date],"aaa",'calendar'[Net Churn % WoW Change])
return
IF(isinscope('calendar'[date]),'calendar'[Net Churn % WoW Change],SUMX(_b,[aaa]))

 If I have  misunderstood your meaning, you can create simple data with excel, then show me the screenshots about the data and the desired output your want.

Best regards.

[Greg_Deckler]

@ROG This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907