measurement of LW not work

[WaelTalaat79]

Dears,

i face an issue in calculating the total CP value of last week figures knowing that the data dates is a weekly data

[Ritaf1983 · Accepted solution]

Hi @WaelTalaat79 
This is a screenshot, nut it seems a standard week vs the previous scenario.
please refer to the linked tutorials:
https://www.youtube.com/watch?v=YuiUymUP5Kc

https://www.youtube.com/watch?v=7_Q5yaU-Fjc

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous · Accepted solution]

Hi, @WaelTalaat79 

Based on your question, I think the problem may be in 'EOL Follow up'[Date]='EOL Follow up'[Date]-7, you can make changes to this string of code.

The modification I made was to display the value of 1/22/2024 so that the Measure value can be displayed properly, this is my DAX code:

Measure = 
VAR _AA = MAXX(ALLSELECTED(EOL),'EOL'[Date])
RETURN SUMX(
    FILTER(
        EOL,
        EOL[Date] = _AA-7
    ),
    EOL[TOTAL CP VALUE]
)

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

How to Get Your Question Answered Quickly 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi, @WaelTalaat79 

Based on your question, I think the problem may be in 'EOL Follow up'[Date]='EOL Follow up'[Date]-7, you can make changes to this string of code.

The modification I made was to display the value of 1/22/2024 so that the Measure value can be displayed properly, this is my DAX code:

Measure = 
VAR _AA = MAXX(ALLSELECTED(EOL),'EOL'[Date])
RETURN SUMX(
    FILTER(
        EOL,
        EOL[Date] = _AA-7
    ),
    EOL[TOTAL CP VALUE]
)

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

How to Get Your Question Answered Quickly 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[WaelTalaat79]

No, it is not work, how can i attach a sample file

EOL test.pbix

[Anonymous · Accepted solution]

Hi @WaelTalaat79 ,

According to the pbix file you provided, I have modified the DAX code for Measure.

Total LW new = 
VAR _AA = MAXX(ALLSELECTED('EOL Follow up'),'EOL Follow up'[Date])
VAR _currentItem = SELECTEDVALUE('EOL Follow up'[ITEM])
RETURN SUMX(
    FILTER(
        ALL('EOL Follow up'),
        'EOL Follow up'[Date] = _AA-7
        &&
        'EOL Follow up'[ITEM]=_currentItem
    ),
    'EOL Follow up'[TOTAL CP VALUE]
)

So that Measure can get the relevant data.

Use the all(), allselected(), allexcept(), and removefilter() functions to remove unwanted filtering effects.

Here's a blog about contextual filtering, which you can start with the highlights: Understand the Filter Context and How to Control i... - Microsoft Fabric Community

[WaelTalaat79]

Nice, thank you
but why the total measurement column total not appear 

[Ritaf1983]

You can save it on some kind of drive and share via link.

[WaelTalaat79]

EOL test.pbix

[Ritaf1983]

Hi @WaelTalaat79 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[WaelTalaat79]

[Ritaf1983 · Accepted solution]

Hi @WaelTalaat79 
This is a screenshot, nut it seems a standard week vs the previous scenario.
please refer to the linked tutorials:
https://www.youtube.com/watch?v=YuiUymUP5Kc

https://www.youtube.com/watch?v=7_Q5yaU-Fjc

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly