DAX and Modeling Question

[PIYUSHPRAJAPATI]

If i filter the Type from the visual then only Beam and Column Visuals value filter but below that visuals value not filter why can any one can give me suggestion or Solution. 

PowerBI File :  https://drive.google.com/file/d/1ij5E5RG5AM9ZMEV10R4AgMM-7rrqm_jP/view?usp=drive_link 

Video Link of the Issue : https://drive.google.com/file/d/1HsSTpw66q1Wny2ztKnUBLzyZVjy8_z3r/view?usp=drive_link

Please anyone give me the solution.

[PIYUSHPRAJAPATI · Accepted solution]

Here is the video how i want the solution: https://drive.google.com/file/d/1N6mNlsW5FitCo8QIlIBW2EwmnjL5wOWI/view?usp=drive_link 

I solved by only using the merged table that previously mentioned in the PBIX file if you have another way then please you can share.

[Anonymous]

Hi, @PIYUSHPRAJAPATI 

Glad to hear you solved the problem yourself!  
If you can, please make your solution Accept as Solution, which will be beneficial for future users to read this post.

Best Regards

Yongkang Hua

[lucadelicio]

Hi @PIYUSHPRAJAPATI 
use single relationship.

Both relationship only if you really need.

As attachment pbix project.

Try to see if now is as you want.

Otherwise explain with more details the result that you want.

MARK AS SOLUTION IF I HELP YOU