Total is not working

[LoryMenCR]

Dear All,

I have the following measure in a table:

Saldo_ANALITICA =

-- SUMX [Saldo Ripartito] con Ammortamenti divisi per il mese di riferimento

VAR MESECOMP = SUMX(DISTINCT(CalendarTable[Month Number]), CalendarTable[Month Number])

RETURN

IF(

    OR (CONTAINS(Q_ANALITICA, Q_ANALITICA[TPC_CODICE_FULL], "4 40 11"), CONTAINS(Q_ANALITICA, Q_ANALITICA[TPC_CODICE_FULL], "4 40 12" )),

    (SUMX(Q_ANALITICA, Q_ANALITICA[Saldo ripartito]) / MESECOMP),

    SUM(Q_ANALITICA[Saldo ripartito])

)

It does work, but Total is not correct because the measure divides it by var MESECOMP.

Do you know how can I fix this Total issue?

Thx a lot

[lbendlin]

what is 

VAR MESECOMP = SUMX(DISTINCT(CalendarTable[Month Number]), CalendarTable[Month Number])

supposed to achieve?

[LoryMenCR]

Dear @lbendlin,

var MESECOMP gives back the distinct number of month calendar by which I want to divide the value of rows when TPC_CODICE_FULL = "4 40 11" and "4 40 12"

[lbendlin]

no, it adds up the month numbers.

[Greg_Deckler · Accepted solution]

@LoryMenCR First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, 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

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

If none of that helps, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[LoryMenCR]

Thanks @Greg_Deckler . I solved this by using this:

m_Total 1 = 
VAR __table = SUMMARIZE('Table1',[Name],"__value",[m_Single])
RETURN
IF(HASONEVALUE(Table1[Name]),[m_Single],SUMX(__table,[__value]))

[Greg_Deckler]

@LoryMenCR Looks right to me!