Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
My current % parent row total measure works fine based on Month slicer i.e. dataset date range is for 2020 only
VAR Month = SELECTEDVALUE('Calendar'[MonthNum])
Return
DIVIDE(SUM(FreightForward[JOBCOUNT]) , CALCULATE(SUM(FreightForward[JOBCOUNT]) , ALLSELECTED(FreightForward) , 'Calendar'[MonthNum] = Month) , BLANK())
However, my dataset has been extended to previous year 2019, so the above measure does not show correct % row total when YEAR slicer is introduced. How do I modify measure to reflect correct result?
Solved! Go to Solution.
Like this?
VAR Month = SELECTEDVALUE('Calendar'[MonthNum])
VAR _Year = SELECTEDVALUE('Calendar'[Year])
Return
DIVIDE(SUM(FreightForward[JOBCOUNT]) , CALCULATE(SUM(FreightForward[JOBCOUNT]) , ALLSELECTED(FreightForward) , 'Calendar'[MonthNum] = Month, 'Calendar'[Year] = _Year ) , BLANK())
Please mark as solution if so. Thumbs up for the effort are appreciated.
Kind regards,
Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Like this?
VAR Month = SELECTEDVALUE('Calendar'[MonthNum])
VAR _Year = SELECTEDVALUE('Calendar'[Year])
Return
DIVIDE(SUM(FreightForward[JOBCOUNT]) , CALCULATE(SUM(FreightForward[JOBCOUNT]) , ALLSELECTED(FreightForward) , 'Calendar'[MonthNum] = Month, 'Calendar'[Year] = _Year ) , BLANK())
Please mark as solution if so. Thumbs up for the effort are appreciated.
Kind regards,
Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
User | Count |
---|---|
15 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
18 | |
15 | |
7 | |
5 |