Total

[kasife]

Hey guys,
I would like to get the count of distinct projects following two conditionals:
- projects up to the current month
- real column smaller than U.H ou lote column
My measurement is also counting the dates of the month of December and should add up to November, which is the current month. How could I get this result?

IF( SELECTEDVALUE(fRealizado[Dt. Lançto Módulo (1º Repasse/Venda)]) <= TODAY(),
    CALCULATE(
        DISTINCTCOUNT(fRealizado[Codigo]),
        USERELATIONSHIP(dCalendario[Date],fRealizado[Dt. Lançto Módulo (1º Repasse/Venda)])))

[Greg_Deckler · Accepted solution]

@kasife 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

[kasife]

@Greg_Deckler thanks. 
I voted.