Forum Discussion

M4R10's avatar
M4R10
Frequent Visitor
8 years ago

Same items sales

I am looking for a way to build a filter that allows me to consider the sales for the same list of items through selected stores.
This means, consider the list of products that have sales greater than zero in all selected stores.

 

For example:

STORE A has sales for the folloing list of items:

item 1

item 2

item 3

item 4

 

and STORE B has sales for the following list of items:

item 3

item 4

item 5

 

The result that I'm looking for is:

TOTAL SAME ITEMS SALES for STORE A + STORE B should only consider:

item 3

item 4

 

thanks in advance for any help

 

regards,

Mario

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi M4R10,

     

    >>The result that I'm looking for is: TOTAL SAME ITEMS SALES for STORE A + STORE B should only consider:

    Current power bi slicer/filter not support this feature.
    In my opinion, I'd like to suggest you write a measure to check with variable table(create by INTERSECT function) and return the tag.

     

    Tag = 
VAR current_T1 =
    LASTNONBLANK ( T1[Items], [Items] )
VAR current_T2 =
    LASTNONBLANK ( T2[Items], [Items] )
VAR Selected =
    INTERSECT ( ALLSELECTED ( T1[Items] ), ALLSELECTED ( T2[Items] ) )
RETURN
    IF ( current_T1 IN Selected || current_T2 IN Selected, "Y", "N" )

    Then drag this measure to visual level filter, switch to 'is' mode and filter on tag 'Y'.

     

    Regards,

    Xiaoxin Sheng

    • M4R10's avatar
      M4R10
      Frequent Visitor
      8 years ago

      thanks Anonymous

       

      I don't understand if your suggestion works for my model:

      When you suggest to use two VARs related to T1[Items] and T2[Items], how should I take it considering I have only 1 items table?

       

      What  Im trying to do is make a "live" inner join applied to items depending the store(s) selection

       

      regards