Forum Discussion

prashantg364's avatar
prashantg364
Icon for Helper II rankHelper II
3 years ago
Solved

DAX support -Column

I am having a table as shown below date Serviceid servicestatus 6-2-23 1001 complaint_1 11-2-23 1002 complaint_2 25-2-23 1003 complaint_3 28-2-23 1004 resolution_1 3-...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, prashantg364 

     

    You can try the following methods.

    Result = 
Var _N1=CALCULATE(COUNT('Table'[Serviceid]),FILTER('Table',SEARCH("complaint",[Servicestatus],,0)<>0))
Var _N2=CALCULATE(COUNT('Table'[Serviceid]),FILTER('Table',SEARCH("resolution",[Servicestatus],,0)<>0))
Return
IF(_N2<>BLANK(),_N1+1,BLANK())

    Is this the result you expect?

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, prashantg364 

 

You can try the following methods.

Result = 
Var _N1=CALCULATE(COUNT('Table'[Serviceid]),FILTER('Table',SEARCH("complaint",[Servicestatus],,0)<>0))
Var _N2=CALCULATE(COUNT('Table'[Serviceid]),FILTER('Table',SEARCH("resolution",[Servicestatus],,0)<>0))
Return
IF(_N2<>BLANK(),_N1+1,BLANK())

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.