Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago
Solved

Budget Allocation without relationship

Hi,   I'm wondering can we calculate Budget, without relationship ?   For example I have this table Dealer Region Branch Year Month WO group Budget DEMF Washington Reg Washington ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi admin_xlsior 

    You may try below measure or just use budget table's region column as slicer.For further,please refer to attached sample file.

    Measure =
VAR CurrentMonth =
    SELECTEDVALUE ( 'Date'[Month] )
VAR CurrentRegion =
    SELECTEDVALUE ( 'Region'[Region] )
VAR MonthlyBudgetAmt =
    CALCULATE (
        [Total Budget-GP],
        FILTER (
            ALL ( 'Budget' ),
            CurrentMonth = 'Budget'[Month]
                && CurrentRegion = 'Budget'[Region]
        )
    )
RETURN
    MonthlyBudgetAmt

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi admin_xlsior 

You may try below measure or just use budget table's region column as slicer.For further,please refer to attached sample file.

Measure =
VAR CurrentMonth =
    SELECTEDVALUE ( 'Date'[Month] )
VAR CurrentRegion =
    SELECTEDVALUE ( 'Region'[Region] )
VAR MonthlyBudgetAmt =
    CALCULATE (
        [Total Budget-GP],
        FILTER (
            ALL ( 'Budget' ),
            CurrentMonth = 'Budget'[Month]
                && CurrentRegion = 'Budget'[Region]
        )
    )
RETURN
    MonthlyBudgetAmt

Regards,