Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We need to calculate the number of orders.
Create
a calculated measure that uses the COUNTA(Order_ID) DAX formula?
OR
a calculated measure that uses the SUM (Order_ID) DAX formula?
OR
a calculated column that uses the SUM (Order_ID) DAX formula?
OR
a calculated column that uses the COUNTA (Order_ID) DAX formula?
which one is right?
Solved! Go to Solution.
Hi buddy,
Try use a measure with:
DISTINCTCOUNT([NoORDER])
this would give you the number of distinct Nº of orders.
Any questions, ask 😉
Hi,
The first one is correct.
Hi buddy,
Try use a measure with:
DISTINCTCOUNT([NoORDER])
this would give you the number of distinct Nº of orders.
Any questions, ask 😉
@Anonymous wrote:Hi buddy,
Try use a measure with:
DISTINCTCOUNT([NoORDER])
this would give you the number of distinct Nº of orders.
Any questions, ask 😉
Thanks for answer. Can you explain which is correct from below 1 and 2?
1 a calculated measure that uses the COUNTA(Order_ID) DAX formula?
OR
2 a calculated measure that uses the SUM (Order_ID) DAX formula?
OR
a calculated column that uses the SUM (Order_ID) DAX formula?
OR
a calculated column that uses the COUNTA (Order_ID) DAX formula?
Hi,
The first one is correct.
A simple
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |