The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello All,
I want to show Avg number of Versions created (By Draft and Published and Total) for every quotation. It means, if quoteNo BLR-XXXXXXX have versions from version 0.1 to version N.
I want the avg number of versions created for that quoteNo in draft as well as published.
Here draft and published are status. you can see the below sample data.
Please suggest me or share a sample pbix file to achieve avg number of versions created on the particular status.
Thanks a ton in advance.
HI @mehaboob557,
Based on your description, you want to get the average of 'draft count' of each no, right?
If this is a case, you can try to use below measure:
Average Count = AVERAGEX ( SUMMARIZE ( FILTER ( ALL ( 'avg versns' ), [status] = "Draft" ), [quoteNo], [status], "Count", COUNTA ( [quoteNo] ) ), [Count] )
Regards,
Xiaoxin Sheng
Hi,
Share the link from where we can download your file. Also, please show the expected result for a few lines.
Hello @Ashish_Mathur,
please find a sample csv file of my data here
https://www.dropbox.com/s/ml1bbmbgfjz664y/avg%20versns.csv?dl=0
Hi,
While i am still not clear about what you exactly want, try this
=COUNTA([version])
In the image below, i have sorted the "Number of versions" column in descending order.
Hi @Ashish_Mathur,
my requirement is .. i have draft status for one quote(blr-XXXXX0) .. This quote will have n number of versions... So, i want to calculate average versions sent to customer(from version 1 to some verion 3). same like wise for all status for that particular quote.
@CahabaData and @v-shex-msft given some suggestion... i will check and reply.
if you have any way, plz suggest me @Ashish_Mathur
Hi,
Where does my current solution fall short of your expectation? Please let me know.
to clarify:
count the rows with 'draft' per unique quoteNo, then average that data set - resulting in a single number
repeat the same only with 'published' rows
yes?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
82 | |
64 | |
58 |
User | Count |
---|---|
248 | |
123 | |
112 | |
79 | |
78 |