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 🙂
hi agarwala
Have you tried Power BI LOOKUPVALUE | Examples of LOOKUPVALUE Dax Function function to achieve the same ?
Regards,
Ritesh
Please mark the answer if helpful so that it can help others as well
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.