If the Skilltarget ID having Multiple POD's, If _pod = "_POD" then we should so blank for others POD

[basirve]

Dear Experts,
If the Skilltarget ID having Multiple POD's, If _pod = "_POD" then we should so _POD Value else we will show Blank() 
Note: Some SkilltragetId's dont have _POD ='_POD' then we can show Actual Value(Like NorthEAST,West) and also Data was populated base on date range (slicer).
How to Give priority for POD as first priority in DAX ?

How to achive this scenerio Could you please help me .

Thanks & Regards,

Venkat.

[basirve]

Can we filter for slicer Datarange in this above Calculated Column  ?
Could you please suggest your thoughts

[ryan_mayu]

I think you can do that. please have a try and let me know if you have any questions.

[ryan_mayu · Accepted solution]

@basirve 

pls try this

Column = IF(CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Skilltarget ID]))>1 && 'Table'[_POD]="_POD", blank(),'Table'[_POD])