Forum Discussion
AverageX
Hello - I have a question about this measure. I am using it to compute the average number of days between when an Opportunity was created, and when it was closed. M
When I put the result on a card visual, it says 3 million (which is obviously not right). I have the measure set to "don't summarize" in the top ribbon bar.
In the Visualzations area, I do not have a "don't summarize" option...just sum...average...min...max...ect. So, if I select "Average", it then gives me a number of 111. Although certainly more realistic than 3 million, what I don't understand is why do I need to even select anything (sum, average, whatever)?
Doesn't the measure itself already imply that the result should be the "average"?
Anonymous if you added this as a column, it will automatically summarize if you use it in a card visual, and probably that's why you see this funny number. You need to add a measure.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
1 Reply
Anonymous if you added this as a column, it will automatically summarize if you use it in a card visual, and probably that's why you see this funny number. You need to add a measure.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡