Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am having trouble converting this tableau formula to DAX.
Could you please help ?
Tableau calculation:
sum({ INCLUDE [Number] : countd(
if
[Country]='FRANCE'
and [Distance]>0
then [Product Code]
END)})
/
COUNTD(
if
[Country]='FRANCE'
and [Flag Distance]
then [Number]
END)
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |