Deleted

[agarwala]

Deleted

[shafiz_p]

Hi @agarwala  You measure should work. Please check which column you have placed in table rows. The CVEID column should be place in rows from Table2 or in slicer.

[danextian]

Your formula should work as a measure. In what way is it wrong?

[agarwala]

Its showing the count just as 1 instead of 312.

I am going crazy unable to understand why is this happening.

[Ashish_Mathur]

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. 

[ribisht17]

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

[agarwala]

Hello,

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

[ribisht17]

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

[agarwala]

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

[agarwala]

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.

[v-linhuizh-msft]

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.

[agarwala · Accepted solution]

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 🙂