Incorrect measure total in Matrix

[Uzi2019]

Hi Experts,
@Greg_Deckler 
I have tried using summarize, sumx and hasonevalue function still giving incorrect result in total. I have used 3 different measure which I have written below

Measure 1 (getting week days)
Datediff =

VAR Start = MIN('Table'[DATE])

VAR End = MAX('Table'[END_DATE])

RETURN DATEDIFF(Start,End,DAY)+1

Measure 2

%sum = SUM('Table'[sum])/CALCULATE(SUM('Table'[sum]]),ALLSELECTED())

Measure 3
Final=
Var A= 300000/Last day of the month 
Var B= A*( Datediff)
Var C =A*B
Var D= C*(%sum)
return D
I want to show  Final measure in matrix visual agianst month, week and category dimension. Row wise data is showing correctly but at total showing incorrect data.

I

I want answer to be 2032819+544684=2577503 for D 

Any help would be appreciated.

Thank you in advance.

[Tahreem24 · Accepted solution]

@Uzi2019 , Try to use something like below:

IF(HASONEFILTER('Table'[Month]),C*(%Sum),SUMX(VALUES('Table'[Month]),C*(%Sum)))

Hopefully it may help you out.

[Uzi2019]

@Tahreem24 

I got my total corretly. thank you so much.

[Greg_Deckler]

@Uzi2019 So, based on 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, you are really going to need something like MM3TR&R. Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community

Assuming that you have a measure that is working at the month and week levels, I imagine it would be something like:

Measure Total = 
  VAR __CurrentCount = COUNTROWS('Table')
  VAR __AllCount = COUNTROWS(ALLSELECTED('Table'))
  VAR __Total = SUMX('Table',[Month],"__Measure",[This is your existing measure])
RETURN
  IF(__CurrentCount = __AllCount,__Total,[This is your existing measure])

[selimovd]

Hey @Uzi2019 ,

what exactly should the result be?

Can you provide a sample file? It's a little difficult to help you with that small amount of information.

Best regards

Denis

[Uzi2019]

Hi @selimovd ,
I want answer to be 2032819+544684=2577503 for final measure

[selimovd]

@Uzi2019 Can you share the file or create a sample file if the content is confidential? 

[Uzi2019]

Hi @selimovd 

sorry but cant share the file it has confidential data.
can u help me by looking at this image? or suggest some measure which gives correct total.

[selimovd]

@Uzi2019 it looks like it could be semi additive values, but you have to share more information.

If the data is confidential, then please create a similar file with fake data and the same behavior. But if you just say "look, it's wrong" and don't provide more information I don't know what to tell you.