Introducing ISINSCOPE a super useful Power BI DAX to modify TOTAL value displayed in PBI report

% 38

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: www.bensound.com
License code: O511QTCIB3JAADFA
LA131

Опубликовано:

29 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 10

@naylord5 2 месяца назад

Nice tip! Thank you for sharing

@LighthouseAnalytix 2 месяца назад

You are welcome :)

@user-ke4qc1kw9s Месяц назад

Nice, make more videos on DAX like this

@LighthouseAnalytix Месяц назад

Thanks, will do!

@tinaflemons263 Месяц назад

Thank you. How can you use the ties in your data? For example, you only want list top 5. If there is a tie, still only show 5 rows

@LighthouseAnalytix Месяц назад

I am not sure. Thanks for giving me something to think about.

@barttitulaerexcelbart9400 2 месяца назад

Thanks: but you can also do this with "IF HASONEVALUE " ? But I was wondering how you did that in the end with the slicer: with a category "all" ??

@LighthouseAnalytix 2 месяца назад

Hello... thanks for the tips about HASONEVALUE DAX, something that I haven't explored previously and now keen to explore. Glad that you asked about the slicer that I have included in that report, which is displaying the values of the measure. I will be posting a video about it next week.