cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
edayan
Frequent Visitor

Adoption %

Hi @amitchandak ,

This is what I shared in the other post.

I have the following Table Data:

CUST SAP NumberRunYearMonthC17 VolumeC10 Volume
1112020M0736
1122020M07510
1132020M07-8
1112020M0810-
1122020M0811-
1132020M081020

 

 

Requested Output (in BOLD😞 Adoption basically,  what  % of total(count) of customers was creating the volume *every month*..

 

RunYearMonthC17 Adoption C10 Adoption
2020M0766%100%
2020M08100%33%
   

 

thanks!

1 ACCEPTED SOLUTION
AlB
Super User III
Super User III

Hi @edayan 

1. Make sure that the "-" in your data are blanks

2. Place Table1[CUST SAP Number] in a table visual

3. Create these measures and place them in the visual

C17 adoption = 
DIVIDE (
    COUNTROWS (
        FILTER (
            DISTINCT ( Table1[CUST SAP Number] ),
            CALCULATE ( SUM ( Table1[C17 Volume] ) ) <> 0
        )
    ),
    DISTINCTCOUNT ( Table1[CUST SAP Number] )
)
C10 adoption = 
DIVIDE (
    COUNTROWS (
        FILTER (
            DISTINCT ( Table1[CUST SAP Number] ),
            CALCULATE ( SUM ( Table1[C10 Volume] ) ) <> 0
        )
    ),
    DISTINCTCOUNT ( Table1[CUST SAP Number] )
)

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

SU18_powerbi_badge

View solution in original post

2 REPLIES 2
amitchandak
Super User IV
Super User IV

@edayan , Try like

C17 Volume Adopt % = divide(count(Table[C17 Volume]),countrows(Table))

 

C10 Volume Adopt % = divide(count(Table[C10 Volume]),countrows(Table))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

AlB
Super User III
Super User III

Hi @edayan 

1. Make sure that the "-" in your data are blanks

2. Place Table1[CUST SAP Number] in a table visual

3. Create these measures and place them in the visual

C17 adoption = 
DIVIDE (
    COUNTROWS (
        FILTER (
            DISTINCT ( Table1[CUST SAP Number] ),
            CALCULATE ( SUM ( Table1[C17 Volume] ) ) <> 0
        )
    ),
    DISTINCTCOUNT ( Table1[CUST SAP Number] )
)
C10 adoption = 
DIVIDE (
    COUNTROWS (
        FILTER (
            DISTINCT ( Table1[CUST SAP Number] ),
            CALCULATE ( SUM ( Table1[C10 Volume] ) ) <> 0
        )
    ),
    DISTINCTCOUNT ( Table1[CUST SAP Number] )
)

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

SU18_powerbi_badge

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors