Forum Discussion
Fix total in Matrix
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
Hi Anonymous ,
We can create another new measure based on [Net adds].
Measure = SUMX('Date',[Net adds])
4 Replies
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
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
Hi Anonymous ,
We can create another new measure based on [Net adds].
Measure = SUMX('Date',[Net adds])