Countif with data range

[Anonymous]

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?

[v-jayw-msft]

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:

[Anonymous]

Dear @v-jayw-msft ,

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

[v-jayw-msft]

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]

Dear @v-jayw-msft ,

Date and Observation methods are in same column, 

But I want date filter applicable to calculated calcumn.

[Ashish_Mathur]

Hi,

Your formula is correct.  Write that as a measure (not a calculated column).

Hope this helps.

[Anonymous]

Hello @Ashish_Mathur , I am new here, can u help me step by step.

Is it possible to covert calculated column to a measure?

[Ashish_Mathur]

There is no way to convert.  Delete the calculated column formula and go to Modelling > New Measure.

[v-jayw-msft]

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.