Urgent Help, calculation with 1 - measure

[Anonymous]

Help, i've got below calculation, works fine, i need another column B which is 1-A.  (B = (1 - [A])) , but it give me all other years that i don't need. (calculation itself is correct, see pic2)   i did put a page filter which date is on and after 2012. 

[v-shex-msft]

Hi @Anonymous,

You can use if statement with isblank function to filter these blank records:

B = if(ISBLANK([A])=FALSE(),(1 - [A]))

In addition, you can also add a visual level filter to filter the blank records.

Regards,
Xiaoxin Sheng

[Anonymous]

when I change the date to date it's works fine, only wrong when i use the 'Date Hierarchy' format. 

[Anonymous · Accepted solution]

Instead of    B := 1 - [A]   You can probably do...    B := IF ([A], 1 - [A])