Ultimo monthly figure not showing for all periods

[Caah]

Hi,

I have this issue where my measure is not showing a result for all periods. In this case January and March. I can't figure out what is causing this issue? 

[v-yiruan-msft]

Hi @Caah ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the coummunity find the solution easily if they face the same problem with you. Thank you.

Best Regards

[Caah]

Hi, @Jihwan_Kim 

My measure is as below. The issue is not related to having 0 value on the dates.

Backlog - FIX =

SUMX(

SUMMARIZE(Company,Company[Company],

"Backlog", [Backlog - Group currency]),

[Backlog])

------------------

Backlog - Group currency =

VAR CompanySelect = SELECTEDVALUE(Company[Company])

RETURN

SWITCH( TRUE(),

CompanySelect = "STNL",[Order backlog]*CALCULATE('Currency'[Monthly currency],'Currency'[Attribute] = "EUR"),

CompanySelect = "STIT",[Order backlog]*CALCULATE('Currency'[Monthly currency],'Currency'[Attribute] = "EUR"),

CompanySelect = "Nikro",[Order backlog]*CALCULATE('Currency'[Monthly currency],'Currency'[Attribute] = "EUR"),

CompanySelect = "STUS",[Order backlog]*CALCULATE('Currency'[Monthly currency],'Currency'[Attribute] = "USD"),

CompanySelect = "RH",[Order backlog]*CALCULATE('Currency'[Monthly currency],'Currency'[Attribute] = "USD"),

CompanySelect = "FC",[Order backlog]*CALCULATE('Currency'[Monthly currency],'Currency'[Attribute] = "USD"),

CompanySelect = "STJP",[Order backlog]*CALCULATE('Currency'[Monthly currency],'Currency'[Attribute] = "JPY"),

CompanySelect = "STAI",[Order backlog]*CALCULATE('Currency'[Monthly currency],'Currency'[Attribute] = "MYR"),

CompanySelect = "STCN",[Order backlog]*CALCULATE('Currency'[Monthly currency],'Currency'[Attribute] = "CNY"),

CompanySelect = "STBR",[Order backlog]*CALCULATE('Currency'[Monthly currency],'Currency'[Attribute] = "BRL"),

CompanySelect = "STMX",[Order backlog]*CALCULATE('Currency'[Monthly currency],'Currency'[Attribute] = "MXN"),

CompanySelect = "Intercompany", CALCULATE([Intercompany orderbacklog - FIX], REMOVEFILTERS(Company))*-1,

[Order backlog])

_______________________

Order backlog =

CALCULATE([Orderbacklog - (1000)],

FILTER(ALL('Calendar'),

'Calendar'[Week] = MAX('Calendar'[Week]) && 'Calendar'[Month] = SELECTEDVALUE('Calendar'[Month]) && 'Calendar'[Year] = SELECTEDVALUE('Calendar'[Year])))

[v-yiruan-msft · Accepted solution]

Hi @Caah ，

You can create a new measure as below to put on the matrix instead of the measure [Backlog - Group currency]:

Measurea =
SUMX (
    GROUPBY ( 'Calendar', 'Calendar'[Year], 'Calendar'[Month], 'Calendar'[Week] ),
    [Backlog - Group currency]
)

Best Regards

[Jihwan_Kim]

Hi, @Caah 

I am not sure how your measure looks like, but I assume your measure is trying to find the last value for each period.

Please try to check if you have zero value on 31st Jan and 31st Mar.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM