Conversion Issue

Hi Anonymous ,

Suppose you need to retrieve the following table using those filters.

If the table has created relationships with other tables, then you can filter directly. 

If there is no relationship between theses tables, please create the following measure.

Measure = 
CALCULATE (
    [SP],
    FILTER (
        'Table 2',
        'Table 2'[Date] IN ALLSELECTED ( 'Date'[Date] )
            && 'Table 2'[item] = SELECTEDVALUE ( 'Item'[itemName] )
            && 'Table 2'[Product] = SELECTEDVALUE ( 'Product'[ProductName] )
            && 'Table 2'[RU] = SELECTEDVALUE ( Store[RUName] )
    )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.