Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mehaboob557
Resolver IV
Resolver IV

Average number of versions created by status

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.

 

1232.PNG

 

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.

7 REPLIES 7
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Ashish_Mathur
Super User
Super User

Hi,

 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

 

  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.Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
CahabaData
Memorable Member
Memorable Member

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?

www.CahabaData.com

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.