March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 | Calendar 2019 | January 2019 | External | 160.00 |
DEMF | Washington Reg | Washington | Calendar 2019 | February 2019 | External | 220.00 |
DEMF | Washington Reg | Washington | Calendar 2019 | March 2019 | External | 180.00 |
DEMF | Washington Reg | Washington | Calendar 2019 | April 2019 | External | 100.00 |
DEMF | Washington Reg | Washington | Calendar 2019 | January 2019 | Internal | 160.00 |
DEMF | Washington Reg | Washington | Calendar 2019 | February 2019 | Internal | 220.00 |
DEMF | Washington Reg | Washington | Calendar 2019 | March 2019 | Internal | 180.00 |
DEMF | Washington Reg | Washington | Calendar 2019 | April 2019 | Internal | 200.00 |
DEMF | Washington Reg | Washington | Calendar 2019 | January 2019 | Warranty | 160.00 |
DEMF | Washington Reg | Washington | Calendar 2019 | February 2019 | Warranty | 220.00 |
DEMF | Washington Reg | Washington | Calendar 2019 | March 2019 | Warranty | 220.00 |
DEMF | Washington Reg | Washington | Calendar 2019 | April 2019 | Warranty | 260.00 |
DEMF | California Reg | California | Calendar 2019 | January 2019 | External | 160.00 |
DEMF | California Reg | California | Calendar 2019 | February 2019 | External | 220.00 |
DEMF | California Reg | California | Calendar 2019 | March 2019 | External | 180.00 |
DEMF | California Reg | California | Calendar 2019 | April 2019 | External | 160.00 |
DEMF | California Reg | California | Calendar 2019 | January 2019 | Internal | 120.00 |
DEMF | California Reg | California | Calendar 2019 | February 2019 | Internal | 200.00 |
DEMF | California Reg | California | Calendar 2019 | March 2019 | Internal | 100.00 |
DEMF | California Reg | California | Calendar 2019 | April 2019 | Internal | 80.00 |
DEMF | California Reg | California | Calendar 2019 | January 2019 | Warranty | 160.00 |
DEMF | California Reg | California | Calendar 2019 | February 2019 | Warranty | 220.00 |
DEMF | California Reg | California | Calendar 2019 | March 2019 | Warranty | 280.00 |
DEMF | California Reg | California | Calendar 2019 | April 2019 | Warranty | 160.00 |
Then I created this measures :
This is return correct value :
Month | Budget |
January 2019 | 920 |
February 2019 | 1300 |
March 2019 | 1140 |
April 2019 | 960 |
However I wan to add the other filter like Region and Branch. The slicer, and also the table visualization might need to display those value as well.
So at first I tried to add the region frst like this :
It just give me blank value.
Thanks,
Solved! Go to Solution.
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,
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,
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |