Average number of versions created by status

[mehaboob557]

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.

[v-shex-msft]

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

[Ashish_Mathur]

Hi,

Share the link from where we can download your file.  Also, please show the expected result for a few lines.

[mehaboob557]

Hello @Ashish_Mathur,

please find a sample csv file of my data here

https://www.dropbox.com/s/ml1bbmbgfjz664y/avg%20versns.csv?dl=0

[Ashish_Mathur]

Hi,

While i am still not clear about what you exactly want, try this

1. Drag quote number and Status to values in the Table visual
2. Filter the Status column on Draft or Published
3. Write this DAX formula

=COUNTA([version])

In the image below, i have sorted the "Number of versions" column in descending order.

[mehaboob557]

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

[Ashish_Mathur]

Hi,

Where does my current solution fall short of your expectation?  Please let me know.

[CahabaData]

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?