Forum Discussion

bsas's avatar
bsas
Icon for Post Patron rankPost Patron
8 years ago

Using HASONEVALUE and ISFILTERED in Union for table

Hi All,

 

 

I have 2 tables and slicer by weeks, I need to have one table with all values from 1 (slicer has no impact on values) and anly filtered values from 2 (based on slicer). Can I do something like this in power BI?

 

Could I use something like: IF(ISFILTERED (weeks) && HASONEVALUE(weeks)) when using UNION?