Stop Running Total Calculation at Week 3

[Anonymous]

Here is the viz . I dont have date column. Only year, quarter, weeks.

I want that the line should only dislplay till the most recent week.

[aj1973]

Hi @Anonymous 

You can use the filter pane to filter out the blank values or in your measure you add a variable using SELECTEDVALUE 

for Fiscal_Week_c

[Anonymous]

hi @aj1973  

I tried this but it is not working.

[aj1973]

Can you send me a sample of your file please, it would be easier for me.

[Anonymous]

It is work-related data and hence cannot do so. 

which function should I explore if you can take a guess?

[aj1973]

Ok 

You declared the variable but you didn't use it in Return. You need to add MAX(****)= VAR

[Anonymous]

I tried but looks like it is not working.

[aj1973]

Hi @Anonymous 

Try it like this

[Anonymous]

selected value won't work. I already tried this but didn't work.. Thanks for the help.

[aj1973]

Best option left for you is to share a sample of your PBIX with the community. Better than to keep on speculating for solutions and waste time.

Good luck

[v-yiruan-msft]

Hi @Anonymous ,

You can update the formula of the measure [Q3 2022 POS Total] as below and check if it can return the expected result... Please find the details in the attachment.

Q3 2022 POS Total = 
VAR _selweek =
    SELECTEDVALUE ( 'CS Enriched POS'[Fiscal_Week__c] )
RETURN
    CALCULATE (
        SUM ( 'CS Enriched POS'[Q4 2022 POS By Week] ),
        FILTER (
            ALLSELECTED ( 'CS Enriched POS' ),
            'CS Enriched POS'[Fiscal_Week__c] <= _selweek
        )
    )

If the above one can't help you get the desired result, please provide some fake data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[Anonymous]

I appreciate the help but your solution didn't work. If you can create a measure that shows the running total only until week 12 or less and the line disappears after week 12 in the same file you uploaded that might do the trick. Waiting for the solution.

[Anonymous]

Can you please share the dax calculation.

Thanks for the help