row level calculations count not being populated properly

[haadvitha]

[v-kpoloju-msft]

Hi @haadvitha,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to @Jihwan_Kim, for his valuable inputs on this thread.

Could you please share the sample data relevant to this thread, along with the expected outcome? This will help us accurately reproduce the scenario and provide you with the .pbix file. Alternatively, if you have a sample .pbix file, please share the link with us.

Thank you for using the Microsoft Fabric Community Forum.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Please try to create DAX measure instead of using implicit measures.

Count Code1: = 
COUNTROWS (
    SUMMARIZE (
        FILTER ( ALL ( Table2 ), Table2[name] = SELECTEDVALUE ( Table2[name] ) ),
        Table1[variety]
    )
)

[haadvitha]

i am getting error saying variety specified in the summarize function was not found in the input table, because in my original data set, i had many - many relation ship between these tables.

[Jihwan_Kim]

please provide your sample pbix file's link, and then I can try to look into it.

Thank you.