Convert from Tableau into DAX

[HalfFox]

Hi,

So, I really need to convert those 2 formulas from tableau into DAX:

{ FIXED [Nfe] : COUNTD ([Codigo Sap])
and

SUM([Sell Out])/COUNTD ([Nfe])

I tried a couple of different formulas but the results are not even close to what I was looking for

The closest I got was using:

SKU NFE = CALCULATE(DISTINCTCOUNT(SELL_OUT_COMPLETO[CODIGO_SAP]),ALLEXCEPT(SELL_OUT_COMPLETO,SELL_OUT_COMPLETO[NFE]))

And got "97" as result, but the result I was looking for is "4". No idea how to solve this.

[Anonymous]

Hi @HalfFox ,

I'm not very familiar with tableau 's formula. Could you give a sample about the formula calculating. For example: 

Column=SUM('Table'[value])

The column uses to sum the [value] column .

What about the following?

{ FIXED [Nfe] : COUNTD ([Codigo Sap])
and

SUM([Sell Out])/COUNTD ([Nfe])

What the result of the calculation looks like?

How to Get Your Question Answered Quickly 

Best Regards

Community Support Team _ Polly

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