Forum Discussion

ianvalleser21's avatar
ianvalleser21
New Member
2 years ago

DAX FILTERING

Hi, I need help. I have two tables connected in via Power BI relationship. The first table acts as the main one and then the second table contains the survey details for each items. I am trying to co...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ianvalleser21 ,

 

Based on your description, it appears that there is a problem with the dax formula that is not returning the expected counts from the second table.
You just need to filter the "Survey Data" table and here is the corrected formula:

SurveyCount =
CALCULATE (
    COUNTROWS ( 'Survey Data' ),
    FILTER ( 'Survey Data', 'Survey Data'[Surveys] = 1 )
)


Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • ianvalleser21's avatar
    ianvalleser21
    New Member
    2 years ago

    Thank you for the answer. However, whenever I do that it's giving me a weird set of numbers in the table like this one. 

     

    End of WeekSurvey Scoure Count
    1/6/202414,076
    12/30/202314,076
    12/23/202314,076
    12/16/202314,076
    12/9/202314,076
    12/2/202314,076
    11/25/202314,076
    11/18/202314,076
    11/11/202314,076
    11/4/202314,076
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi ianvalleser21 ,

       

      In your case, how are the table relationships constructed and can you provide some test data for me to troubleshoot.


      Best Regards,
      Adamk Kong