Filtering calculation items in a slicer

Подписаться 106 тыс.

Просмотров 15 тыс.

50% 1

Choose between many-to-many relationships and DAX code to filter the most relevant items using another slicer. Indeed, calculation groups cannot use relationships!
Article and download: sql.bi/805830?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

Наука

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

17 июл 2023

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@solangefranco3444 Год назад

Thanks for always sharing good and interesting content! ☺

@randallevans150 Год назад

CIAO FRIENDS! Thanks for the new video.

@abhishek12865a Год назад

your explanation is mind blowing .Please make a video on working with sql query in to power bi for reporting

@Mrsuperkaminey Год назад

As usual, quality content😊

@AgulloBernat Год назад

Very elegant!

@Bharath_PBI Год назад

Not used calculation items, at least this way. But definitely good to know, thank you very much 👍

@MrAstonmartin78 6 месяцев назад

When I use bar chart as a slicer - it doesn't filtering the other bar chart like slicer does. On other barchart I have in subtitle the measure (Fx) that shows total sum. And when I change cintext by slicer - it changes in a right way. When hihglited by bar chart "like a slicer" - it doesn't.

@Bondoz007 Год назад

Great tips and ideas here - Grazia mille

@OM-yn8pt Год назад

Learnt a similar trick from you a long time ago, nice to see it come up again. In the past you used to do "INT ( NOT ISEMPTY ( 'Table' ) ) ", to remove values in a column that did not have data given the current filter selections. Am I misremembering?

@adilumr6359 Год назад

Great video

@zxccxz164 5 месяцев назад

what if you create more calc groups. one for Marco one for alberto. Or be more specific with CG. ie TIME INTEL Calc Groups for Previous Period and Parallel Period instead of bunching them all into one??

@vishal45chauhan Год назад

Hello Alberto, you are really a master of DAX. any idea to show the description/definition of a measure while hovering over the visual.

@kabirhussain1725 8 месяцев назад

Sir, I have two tables one fact sales table and other on Hand stock table. In both matching coloumn is store ID Item ID and. I want total sale and closing stock for each item while using store ID slicer for individual store. Please waiting for your answer

@amarnadhgunakala2901 Год назад

Good to know this

@engr.naeemshahzad8795 Год назад

Please also make a video on time slicer, as i found that there is no satisfactory option available of time slicer in power bi

@laionegan Год назад

Hi SQLBi, this is very interesting but i 'm a little confuse on the part where selectedvalue has been used. The expression selectedvalue(cgroup[items])should return all calc items not only one at the time,right?

@SQLBI Год назад

SELECTEDVALUE returns the value selected, or BLANK if more than one is selected or if there is no selection.

@andreypupchenko2831 Год назад

Really useful video! However, there is a mistake clearly visible at 10:38. Marco doesn't have C5, this looks like redundant value from Alberto. It seems like this is a glitch of Power BI itself.