Creating custom groups using calculation items - Unplugged #24

 https://www.youtube.com/watch?v=l6si02kf4eU&t=600s


Explore how to create custom groups based on a slicer selection in Power BI. For example, create two versions of a measure: one returns the value of the selected items, and another one returns the value of the other items, the ones that are not selected. This and other custom groups can be obtained by manipulating tables in specific calculation items.



Comments

Post a Comment

Popular posts from this blog

Difference between DISTINCT and VALUES in DAX

https://www.sqlbi.com/blog/marco/2011/03/08/difference-between-distinct-and-values-in-dax/   Example: If a  FACT table contains values that do not exist in a related DIMENSION table, a BLANK row is automatically added to the DIMENSION table. This DIMENSION row with the BLANK value will join to any FACT row where the column value does not exist in the DIMENSION. DISTINCT will NOT include the BLANK column in the DIMENSION. VALUES will include the BLANK column in the DIMENSION.
Read more