Forum Discussion

misul's avatar
misul
Helper I
8 years ago
Solved

Dynamic Segmentation - with duplicate rows

Hi,  I am trying to follow this blog post about Dynamic Segmentation. https://www.daxpatterns.com/dynamic-segmentation/   I am stuck on one point - what to do when there are duplicate transactions...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    misul

     

    I have used this MEASURE in the LookUp Table

     

    Measure =
VAR mysales =
    CALCULATE ( SUM ( Table1[Sales] ) )
RETURN
    CALCULATE (
        SUM ( Table1[Sales] ),
        FILTER (
            VALUES ( Table1[Product] ),
            mysales >= SELECTEDVALUE ( CategoryLookup[Lower] )
                && mysales < SELECTEDVALUE ( categoryLookup[Upper] )
        )
    )

     

misul's avatar
misul
Helper I
8 years ago

Zubair_Muhammad I celebrated too early. The current setup doesn't allow me to count the number of rows in each category, which is my final goal.

 

for example: How many products with Sales <15 in 2017 in Region North? 

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi misul

 

To count the products,,,,you can try this MEASURE

 

CountProducts =
CALCULATE (
    DISTINCTCOUNT ( Table1[Product] ),
    FILTER ( ALL ( Table1[Product] ), [Measure] > 0 )
)