Forum Discussion
Deleted
Hello Zhu,
I tried changing the cross filter direction too but it dint work.
At the end I have created the calculated column in table 2 which will store the count of CVE_ID here is the DAX:
COUNTROWS(FILTER('API_SOFTWARE_VULNERABILIITIES_MACHINE','API_SOFTWARE_VULNERABILIITIES_MACHINE'[CVEID] = EARLIER('API_SOFTWARE_VULNERABILIITIES_MACHINE'[CVEID])))And then I referred that in table 1.It solved my issue.
Thank you so much for all the replies to my post 🙂
Hello,
I am not storing the counts in the table I have created the measures so not sure how will I use VLOOKUP here?
hi agarwala
I am not having any problem in getting the answer
Just check of you need to swap table 1 and 2 in the DAX
Regards,
Ritesh
Please mark the answer if helpful so that it can help others as well
Thank you for your suggestions I again tried it today and this is how my table 1 and table 2 looks like:
Table 1 :
Table 2:When I am choosing the row of table 1 table 2 visual shows the count as below:
there is absolutely no relationship between these 2 tables still its changing the count to 2 which is what I am unable to understand and this is the same count I am getting when using the formula above to combine both the tables:
I want the second count to show as 624 and not 2.
Could you pls suggest why is this happening?Cheers
Arti
Hello,
I just realised that these two tables are related to one other table and they have many-to-many relationship with that common table so when I made one of the relationship as inactive it worked absolutely fine:
But in my case I want to keep both the relationships active.
Are there any suggestions on how I could make this work keeping both the relationships active.
Thanks for the replies from shafiz_p, danextian, Ashish_Mathur, ribisht17.
Hi agarwala ,
You can try to change the direction of cross-filtering from both to single and filter the other two tables from the common table. If the problem persists, could you please provide the pbix file with the sensitive data removed to better pinpoint the problem?
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.