Forum Discussion
Solved
Calculate formula using All function
Hi, I am making a Balance Sheet Power BI on consolidated group level and stand-alone companies. Currently I have created a measure which pulls the balance amounts of one such company ALJID = CALCU...
I have used the following formula which is working so far. In addition to FILTER and ALL functions I also added MTD function so it does not add two month at any given time (plus use the filters i want to).
ALJID Total Assets = CALCULATE([ALJID], ALL('TB Data'), AccountMapping[Core Category 1]="Assets", DATESMTD(Date_Lookup[Date].[Date]))Let me know if you have any comments
Hi hussainmw
for the denominator you can use
ALJID = CALCULATE([Total Reporting],ALL('TB Data'[Company]))
this will remove the filter only from the Company column and won't affect the date filter.
however it alk depends on the visual's filter context.
I have used the following formula which is working so far. In addition to FILTER and ALL functions I also added MTD function so it does not add two month at any given time (plus use the filters i want to).
ALJID Total Assets = CALCULATE([ALJID], ALL('TB Data'), AccountMapping[Core Category 1]="Assets", DATESMTD(Date_Lookup[Date].[Date]))
Let me know if you have any comments