resell report

Hi Anonymous

Try the following:

1. Create a new one-column table, FilterTable, with all values of OrderDetails[ItemID] in FilterTable[ItemID]. Set FilterTable[ItemID] in a slicer. This will be used to select the the item of interest.

2. Place a table visual in your report and set in values OrderDetails[ItemID], OrderDetails[OrderID] and OrderDetails[Sales]. Choose "don't summarize" for all three. 

3. Create this measure that will determine what items are to be shown:

ShowMeasure = 
VAR _OrdersList =
    CALCULATETABLE (
        DISTINCT ( OrderDetails[OrderID] );
        OrderDetails[ItemID] IN DISTINCT ( FilterTable[ItemID] );
        ALL ( OrderDetails )
    )
VAR _CurrentOrder =
    SELECTEDVALUE ( OrderDetails[OrderID] )
RETURN
    IF ( _CurrentOrder IN _OrdersList; 1 )

4. Place [ShowMesure] in the visual level filters of the table visual and select "Show values when the value is:" --> 1

Code formatted with