Tableau Fixed calculation to Power BI DAX

[Satishkumarr]

Hi All, 

Could you please help me to convert this Tableau to Power bi DAX.

"ZN(COUNTD(IF [Quarter]>='18-Q4' THEN
IF [LeadNumber] <> 'value' and [MetricName]='value' and [HoldFlag]=1 AND [ActiveCampaignFlag]=1 and
[UniqueInteractionRank]=1
then [LeadNumber] END
ELSE
IF [LeadNumber] <> 'value' and [MetricName]='value' and [HoldFlag]=1 and
[UniqueInteractionRank]=1
then [LeadNumber] END
END))

"

Thanks,

Satish

[v-jianboli-msft]

Hi @Satishkumarr ,

What kind of result do you want? Is it a calculated column or a measure?

Can you elaborate on the logic of your calculation?

Please provide me with more details about the result you want or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

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

[Satishkumarr]

Hi @v-jianboli-msft,

I need a Calculated column, This is a caluclation to define Interactions column.