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] ) )
    )
    )))
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

Please try the below.

Measure 2 = 
VAR _products = ALLSELECTED( 'Table'[Products] ) 
VAR _names =
ADDCOLUMNS( 
    VALUES( 'Table'[CustomerName] ),
    "xxxx", CALCULATE( COUNTROWS( 'Table' ), _products )
)
RETURN COUNTROWS( FILTER( _names, COUNTROWS( _products ) = [xxxx] ) )

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

Mariusz 

You Measure is not working in my environment:

ListOfCustomers =
VAR _products = ALLSELECTED( SALESDATA_CASE1[ITEM_CODE])
VAR _names =
ADDCOLUMNS(
VALUES( SALESDATA_CASE1[CustCode_CaseOne] ),
"xxxx", CALCULATE( COUNTROWS( SALESDATA_CASE1 ), _products )
)
RETURN COUNTROWS( FILTER( _names, COUNTROWS( _products ) = [xxxx] ) )
 
I m getting blank values, though actual value isnt blank. I m using Page level filters
Any more information you required to help me on this?
Thanks in Advance!