Posts

Showing posts with the label COMPLEX MEASURE

Fixing “Top N and others” report when filtering by date - Unplugged #35

  https://www.youtube.com/watch?v=eoEbnQyianU
Post a Comment
Read more

Optimizing AND Logic in Slicers

https://www.sqlbi.com/tv/optimizing-an-old-sqlbi-article-and-logic-in-slicers-unplugged-4/  
Post a Comment
Read more

Filter top 3 products with a row for others using DAX in Power BI

  https://www.youtube.com/watch?v=nVvlEHKr_0o https://www.sqlbi.com/articles/filtering-the-top-products-alongside-the-other-products-in-power-bi/
Post a Comment
Read more

Apply AND Logic to Multiple Selection in DAX Slicer

  https://www.youtube.com/watch?v=tONOosN1xAs https://www.sqlbi.com/articles/apply-and-logic-to-multiple-selection-in-dax-slicer/
Post a Comment
Read more

Using OR conditions between slicers in DAX

  https://www.youtube.com/watch?v=l5JX3G5Ntzk https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/ Set-Based Solution: Create table to be used as a filter in CALCULATE: UNION Crossjoin the selections in the Product[Brand] slicer with any Customer[Occupation] Crossjoin the selections in the Customer[Occupation] slicer with any Product[Brand] OR   # 1   := CALCULATE   (      [Units] ,      UNION   (          CROSSJOIN   (   VALUES   (   'Product'[Brand]   ) ,   ALL   (   Customer[Occupation]   )   ) ,          CROSSJOIN   (   ALL   (   'Product'[Brand]   ) ,   VALUES   (   Customer[Occupation]   )   )      ) )
Post a Comment
Read more