Forum Discussion

lusalva's avatar
lusalva
Frequent Visitor
9 years ago

Card result based on two different filters

Hi, I have a report where I show some KPIs ( Sales_Values,  Average_sales, Sales_qty, etc...) and I have tow filters: One which I show the information for product 1 and the Second showing the inform...
Show and Tell
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi lusalva,

 

Unfortunately, if we keep the interactions between two slicers, the measures based on them will be affected by both slicer selections, which will bring the unexpected result. 

 

Personally, the best choice is to remove the relationship between two tables and remove the interactions between two slicers. The aim to replicate the original table is to make sure there is no influence with each other.

 

Best regards,
Yuliana Gu

lusalva's avatar
lusalva
Frequent Visitor
9 years ago

Thank you