Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all
Solved! Go to Solution.
Sorry for my mistake, I should enter, not /
Total Sales =
DIVIDE(
SUMX(
Sales,
Sales[Order Quantity] * Sales[Unit Price]
)
,
10000
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Modify and try like this:
Total Sales =
DIVIDE(
SUMX(
Sales,
Sales[Order Quantity] * Sales[Unit Price]
)
/
10000
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Fowmy
Many thanks for your solution.
I seem to be getting an error with the updated formulae. I have included a photo. "Too few arguments were passed to the DIVIDE function. The minimum argument count for the function is 2"
Sorry for my mistake, I should enter, not /
Total Sales =
DIVIDE(
SUMX(
Sales,
Sales[Order Quantity] * Sales[Unit Price]
)
,
10000
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |