Forum Discussion

haadvitha's avatar
haadvitha
New Member
1 year ago
Solved

row level calculations count not being populated properly

  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    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]
    )
)

     

     

4 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    1 year ago

    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's avatar
      haadvitha
      New Member
      1 year ago

      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's avatar
        Jihwan_Kim
        Icon for Super User rankSuper User
        1 year ago

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

        Thank you.

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    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.