Forum Discussion

agarwala's avatar
agarwala
Icon for Helper I rankHelper I
1 year ago
Solved

Deleted

Deleted
Need Help
  • agarwala's avatar
    agarwala
    1 year ago

    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 🙂
     
     
agarwala's avatar
agarwala
Icon for Helper I rankHelper I
1 year ago

Hello,

 

I am not storing the counts in the table I have created the measures so not sure how will I use VLOOKUP here?