Ever wish to know if there is a DAX function that can allow you to modify the value displayed in the TOTAL row??? ISINSCOPE is the answer.
With ISINSCOPE, you can specify a criteria to be applied to the TOTAL and the NON TOTAL line items.
Hope you find this video useful.
Cheers,
Isabella Susilowati
@LighthouseAnalytix #Powerbi, #powerbitutorial, #powerbitutorialforbeginners
Timelines:
00:00 Intro
01:16 How do we solve this problem
01:23 IsInScope
02:47 Epilogue
Royalty Free Music: https://www.bensound.com
License code: O511QTCIB3JAADFA
LA131