Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Intersection Problem

CustomerName Products Mayank OCEG2 Mayank BRT3 Lithia BRT3 Lithia JOG0 Lithia JHOT8 Chrils HGY7 Shantanu JOG0 Jennifer JOG0 Jennifer OCEG2 Jennifer JHOT8 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    for Intersection, i guess this below measure also helpful:

     


    IF (
    ISBLANK (
    CALCULATE(COUNTROWS (
    FILTER (
    SUMMARIZE (
    Cust_table,
    Cust_table[CUST_CODE],
    "ProductsBought", DISTINCTCOUNT ( Sales[SKU])
    ),
    [ProductsBought] = COUNTROWS ( VALUES ( Sales[SKU] ) )
     
    ))
    ))
    ,
    0,
    CALCULATE(COUNTROWS (
    FILTER (
    SUMMARIZE (
    Cust_table,
    Cust_table[CUST_CODE],
    "ProductsBought",DISTINCTCOUNT ( Sales[SKU])
    ),
    [ProductsBought] = COUNTROWS ( VALUES ( Sales[SKU] ) )
    )
    )))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI,

Mariusz 

My intersection problem is solved. Thank you so much.

But measure 2 is not working for rest of the product combination. Can you please re-check Measure2?

 

Thank you!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

for Intersection, i guess this below measure also helpful:

 


IF (
ISBLANK (
CALCULATE(COUNTROWS (
FILTER (
SUMMARIZE (
Cust_table,
Cust_table[CUST_CODE],
"ProductsBought", DISTINCTCOUNT ( Sales[SKU])
),
[ProductsBought] = COUNTROWS ( VALUES ( Sales[SKU] ) )
 
))
))
,
0,
CALCULATE(COUNTROWS (
FILTER (
SUMMARIZE (
Cust_table,
Cust_table[CUST_CODE],
"ProductsBought",DISTINCTCOUNT ( Sales[SKU])
),
[ProductsBought] = COUNTROWS ( VALUES ( Sales[SKU] ) )
)
)))