Calculated Column

[Anonymous]

Hello Team,

I have a calculated column which is POR 

The formula is [Qty]*[Cost]

Is there a way to create a placeholder field using the POR to divide them into two classification:

POR > 300000 THEN "Above 300k"

POR < 300000 THEN "Below 300k'

I tried creating IF but it does not filter correctly.

[V-pazhen-msft]

@Anonymous 

Seems it is the problem of relationship. Without the pbix model it is hard to detect. You can try create a measure instead a column:

Measure  = IF( MAX('Historical_POR'[POR]) > 300000, "HIGH", "LOW"))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[vaishnaviudan]

You can create another calculated column using IF statement.

Column_POR = IF(TableName[POR]>=300000, "Above 300k", "Below 300k")

[Anonymous]

i got values more than 300k, but it does show in the filter for values above 300000

[Anonymous]

[Anonymous]

hello @vaishnaviudan this is not working properly i do not know why

[FarhanAhmed]

You can create another calculated column based on this calcualted column using IF statement.

IF(Table[POR] >300000, "Above 300k", "Below 300k")

[Anonymous]

I did this but it does not have above 300k selection, although i got some POR with more than 300k,

Formula: 

300K POR = IF('PMMT Historical Data'[POR] > 300000,"Above","Below")

[rks]

Try this:

[Anonymous]

@rks still showing incorrect result. werid..

[rks]

That's indeed strange. I thought the iterator would work (getting the correct row context for each historical por record). 

My last try would be to iterate of each row like this:

Test = MAXX('Historical_POR',

IF( 'Historical_POR'[POR] > 300000, "HIGH", "LOW")

)

[rks]

Can you post a screenshot from the table view where you applied the formular for the calc. column?

Please also send a screenshot from the calc. of POR.

[Anonymous]

300K POR = IF(('PMMT Historical Data'[POR]) > 300000,"Above","Below")