cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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!

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
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

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.