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?
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.
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.
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??
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
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?
your explanation is mind blowing .Please make a video on working with sql query in to power bi for reporting
Thanks for always sharing good and interesting content! ☺
CIAO FRIENDS! Thanks for the new video.
As usual, quality content😊
Great tips and ideas here - Grazia mille
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?
Very elegant!
Great video
Hello Alberto, you are really a master of DAX. any idea to show the description/definition of a measure while hovering over the visual.
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.
Please also make a video on time slicer, as i found that there is no satisfactory option available of time slicer in power bi
Not used calculation items, at least this way. But definitely good to know, thank you very much 👍
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.
It's probably because of the default value of the slicer that remains in C5 without changin automatically on the Marco's selections.
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??
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
Good to know this
Can we apply a similar technique to change the ordinality of the calculation items?
No the order is defined by the Ordinal property and cannot be dynamic.
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?
SELECTEDVALUE returns the value selected, or BLANK if more than one is selected or if there is no selection.
"CurrentCalcItem IN CurrentUserSelection" without FILTER() 🤔
Wow! Concise code 🙂
that moment when your jaw drops.
Beauty