Creating measures where the calculations are based on the current table

[Anonymous]

Hi all,

I have just started learning Power BI and need some help. I have tried to search for a solution in the forumn however, I can't seem to find a solution. 

I created the measure shown below. 

FY18 Actual = (CALCULATE(SUM([Value]),'2_SummaryOfRevenueType$'[Category]="FY18 Actual"))

Note that the table is called 2_SummaryOfRevenueType$

When I use this same measure as part of another table called 3_SummaryOfIncomeType$

The calculations are still based on the above table. How to change the measure so that the calculations are based on the current table?

[Anonymous]

I'd strongly recommend you learn a bit about Power BI and DAX, even before you start asking any kind of questions. Otherwise, you'll be acting like a monkey that's been given a razor...

This can get you started:

https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics

and

https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

Best
Darek