Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Countif with data range

Dear all,

 

I have below code 

CountofSWA = COUNTROWS(FILTER(Observations,'Observations'[Observation Method]="safety Walkaround"))
 
But these are not changing when changing date filter of a table.
 
How can I Make them change with change in table data values?
Need Help
Show and Tell

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi Anonymous ,

     

    I create a demo according to your description:

     

     

     

     

     

     

     

     

    Manage relationship between table “observation” and table “date”:

    Create measure according to your code:

    Result would be changed after changing values of slicer:

    If this demo doesn’t meet your expectations, any test data would be helpful if you can provide.

    Hopefully works for you, BTW, PBIX as attached.

     

    Community Support Team _ Jay Wang

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Dear Anonymous ,

     

    I have date in same table and not different one, How do I create relationships between column headers of same table?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi @bhuvanasundar,

       

      As far as I’m concerned, If “date” column and “Observation Method” column are in the same table then there’s no need to create relationship.

      You can create a slicer or a filter on the visual.

      Results would be shown as below:

      Pbix as attached.

      If this still doesn’t meet your expectations, could you please provide some test files or expect visual?

       

      Community Support Team _ Jay Wang

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Dear Anonymous ,

         

        Date and Observation methods are in same column, 

         

        But I want date filter applicable to calculated calcumn.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi Anonymous ,

     

    Please use measure instead of calculated column.

    Common ways to create measure:

    Different results between measure and calculated column would be shown as below: