Fix total in Matrix

[Anonymous]

Dear Power BI community,

I would like to ask for your support. I'm tryng for some time to fix the yearly total of a measure in a matrix visual.

Namely, the situation is the following:

Below I have customer table with Gross Adds, Churn, Customers EoP(end of period) while the Net Adds are calculated with measure. Monthly Net Adds are calculated as Net Adds=Customers EoP - Customers EoP (Previous Month) if previous value exists or Net Adds = Gross Adds +Churn if there is no previous month e.g. January

I created the following measure :

Net Adds = if (HASONEFILTER('Date'[Calendar Month]),if(ISBLANK([Customers pe LM]),[GrossAdds]+[Churn],[Customers pe]-[Customers pe LM]),xxxx)

but, cannot figure out how to define the formula in the first IF statement for the false condition in case there is no filter for months i.e. total

Thanks a lot,

Goran

[v-frfei-msft]

Hi @Anonymous ,

To use ISFILTERED function to have a try for the taotal value. If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here

[Anonymous]

Hi,

Thank you very much! I created .pbix file and uploaded on OneDrive. Here is the link:

https://1drv.ms/u/s!AliFKUKcaHYIkp4S-0WrPNwcX0OGRA?e=WtFpYP

The correct total for Net Adds should be sum of montlhy values or 8.515

Thank you,

Goran

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

We can create another new measure based on [Net adds].

Measure = SUMX('Date',[Net adds])

[Anonymous]

It works! Thank you very much for your support!

Br, Goran