Need to convert qlik expression to DAX

[datanalyst1]

Hello everyone,

I am trying to change a formula from qlik to dax but cannot find a solution.
Qlik expression is this one:

measure = count({<[Order Status] = {'Invoiced','Delivered','Returned'}>} DISTINCT Total [N° Order])

I would need the measure to show the same total in each row of the column.
Can someone please help me?

[sagrawa]

sum(aggr(
(sum(CustTable.AccruedDebit) - sum(CustTable.AccruedCredit)) + sum(CustTable.AccrualAmount), CustTable.%Account_Key))

[v-jingzhang · Accepted solution]

Hi @datanalyst1

You may create a new column with below DAX. Is this what you want? 

Count = CALCULATE(DISTINCTCOUNT('Table'[N° Order]), FILTER('Table','Table'[Order Status] IN {"Invoiced", "Delivered", "Returned"}))

If I don't understand it correctly, can you please provide some sample data and expected output in table format? I don't have experience in Qlik so the sample data and expected output can help me understand your requirement better. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.