Forum Discussion

agarwala's avatar
agarwala
Helper 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 🙂
     
     
Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

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.