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 th...
Need Help
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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi M4R10,

     

    Share the link from where i can download your file.

    • M4R10's avatar
      M4R10
      Frequent Visitor
      8 years ago

      Hi Ashish_Mathur

       

      I have uploaded the file to the following link:

      https://we.tl/19AdsYIm1e

       

      In this "Price" sampling I'm trying the apply the same rule regarding to identify "same items" across different days / stores.

      thank you for any help.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        There is no file there.