Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Please see below the following example:
I have a slicer on column period (a month has two periods in this case). If i make a selection on a period i need to see the sales for that specific period only, but i need the budget number over the two periods (month) combined.Somehow i need to filter the budget on a month number based on my first selection.
So in this case i should see the sales: 14 budget: 35
Period | Sales | Budget | Month | Year |
012018P1 | 10 | 15 | 1 | 2018 |
012018P2 | 15 | 20 | 1 | 2018 |
022018P1 | 14 | 22 | 2 | 2018 |
022018P2 | 14 | 13 | 2 | 2018 |
032018P1 | 13 | 15 | 3 | 2018 |
032018P2 | 21 | 15 | 3 | 2018 |
042018P1 | 11 | 10 | 4 | 2018 |
042018P2 | 19 | 20 | 4 | 2018 |
Is it possible to achieve this with a dax formule after i have filtered the dataset based on one period?
Thanks!
Solved! Go to Solution.
May be a MEASURE like this for Budget
Budget Sum = VAR myperiod = SELECTEDVALUE ( Table1[Month ] ) RETURN CALCULATE ( SUM ( Table1[Budget] ), Table1[Month ] = myperiod, ALL ( Table1[Period] ) )
May be a MEASURE like this for Budget
Budget Sum = VAR myperiod = SELECTEDVALUE ( Table1[Month ] ) RETURN CALCULATE ( SUM ( Table1[Budget] ), Table1[Month ] = myperiod, ALL ( Table1[Period] ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |