Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |