Blank values in Calculated Column ( I dont want this)

[BirhanAYDS]

Hi everyone,

I have a problem with calculated columns.  In a calculated column I trying to do this calculation: ( I want to find total turnover ratio)

CALCULATE(COUNT(Goals_Employess_View[Id]),Goals_Employess_View[leavedate]>DATE(2020,01,01))/(CALCULATE(COUNT(Goals_Employess_View[Id]),ISBLANK(Goals_Employess_View[leavedate]),Goals_Employess_View[Status]="Active")+CALCULATE(COUNT(Goals_Employess_View[Id]),Goals_Employess_View[leavedate]>DATE(2020,01,01)))*100

In calculated column including another calculations too.

It gets blank value in calculated column but when i do same calculation with measure, it gets to me real calculation. I am confused.

In the picture, TT1 is measure.


Could you help me?

[Anonymous]

Hi @BirhanAYDS ,

Can you show some sample data to us if you don't have any Confidential Information?

Best Regards,

Jay

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.

[amitchandak]

Column work row level, Measure work at the group level.

Please refer:https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

[BirhanAYDS]

Hi,

It's not about like this. In a basically, in this table and for a one row (I give this row so it can find this row) I want to go another table count rows with many filters. I calculated in a measure because I want to certain about it is really blank or not. But now I know this calculation result is not blank value and  ı want to show this calculated value.