Forum Discussion
Deleted
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 🙂
11 Replies
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,
Create a single column Dim tableof CVEID from both tables. Create a many to One relationship from both fact tables to this Dim table. To your visual, drag CVEID from the Dim table.
Your formula should work as a measure. In what way is it wrong?
Its showing the count just as 1 instead of 312.
I am going crazy unable to understand why is this happening.
