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 🙂
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,
Zhu
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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:
Thank you so much for all the replies to my post 🙂