Forum Discussion

souvik900766's avatar
souvik900766
Icon for Helper IV rankHelper IV
5 years ago

Filter out rows

Hi ! My pbix file:-https://www.dropbox.com/s/rgaqhzqakwkbyz9/filter%20problem.pbix?dl=0 When I am selecting any of the category from table 1 the numbers are disappearing in table 2 ! The reason is...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi souvik900766 ,

 

You will need to work with the Data Models. 

 

Try create a 1:Many relationship and then create your measures.

 

Please see Page 2 of the visualization tab in the attached file. It can now show brands according to the categories.

 

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

souvik900766's avatar
souvik900766
Icon for Helper IV rankHelper IV
5 years ago

Hi Anonymous 
No, It is not working !
I am filtering the categories but it is not affecting the brand. Same number of brands are showing for each category !

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi souvik900766 ,

     

    See if this works. Very confusing data as category has value Category 1, Category 2 as well as Brands have value Category 1, Category 2.