AverageX

[Anonymous]

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"?    

Opp Create to Opp Act Close = AVERAGEX(FILTER(SalesLifecycle,SalesLifecycle[Opp Status] = "Closed - Won"), SalesLifecycle[Opp Actual Close] - SalesLifecycle[Opp Create Date])

[parry2k · Accepted solution]

@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.⚡