I have wrong in measure with filter based on governorate

[Saddam]

I have errror in my measure i use the measure to get last week of dataset and when i call it in matrix table based on governorate the value is inccorrect when i call it in card the total is correct, kindly help me how to solve this issue .

the measure is 

mea= CALCULATE(COUNT(dtable[main_id]),FILTER(dtable,dtable[week]=MAX(dtable[week])))

[Anonymous · Accepted solution]

HI @Saddam,

I suppose it should be a multiple aggregate level calculation issues with measure expression, you can refer to Greg’s blog to add a variable with SUMMARIZE function and iterator functions to handle this scenario:

Measure Totals, The Final Word 

mea =
VAR summary =
    SUMMARIZE (
        ALLSELECTED ( dtable ),
        [Category],
        [week],
        "cMain_id", COUNT ( dtable[main_id] )
    )
RETURN
    SUMX ( summary, [cMain_id] )

Regards,

Xiaoxin Sheng

[Saddam]

Hi @Anonymous ,

This measure which you have sent is return All values i just need the data of max week to return in matrix table.

Best Regards 

[Saddam]

Hi Bro, this measure is return All values i just need the data of max week to return.

Best Regards 

[Saddam]

measure in matrix tablemeasure in card 

this screenshoot about this problem