Power BI Tips

 Rename the Calculation Item column name from Name to something else; e.g. same as the name of the Calculation Group is probably okay. When you have a filter on the Calculation Group, you'll see Name if you don't do this. Better to see something more description; e.g. PriceToUse.

  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.

https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/  

Video:  https://www.youtube.com/watch?v=xS1t25_GsWw Article and Video:  https://www.sqlbi.com/articles/using-calculation-groups-to-selectively-replace-measures-in-dax-expressions/ " Calculation groups replace measure references with the DAX expression of the calculation item that is active in the filter context." Shows the "pattern" for injecting any parameter from the report inside a measure as the following steps: Rename calculation group as "Internal..." and hide it Create disconnected table which is a copy of the Internal calculation group Use  disconnected table in slicer to allow user to choose the calculation desired Create "Internal" measure Use CALCULATE to apply calculation item based on user selection Copy disconnected table: PriceToUse  = SELECTCOLUMNS   (      InternalPriceToUse ,      "PriceToUse" ,   InternalPriceToUse[InternalPriceToUse] ,      "Ordinal" ,   InternalPriceToUse[...

  Set categorization on columns; e.g. web image, web URL, geography, etc. Disable summarizing numeric columns that you do not summarize; e.g. key columns Hide columns that are not used in reports; e.g. key columns Disable Auto Date/Time