Adoption %

[edayan]

Hi @amitchandak ,

This is what I shared in the other post.

I have the following Table Data:

CUST SAP Number	RunYearMonth	C17 Volume	C10 Volume
111	2020M07	3	6
112	2020M07	5	10
113	2020M07	-	8
111	2020M08	10	-
112	2020M08	11	-
113	2020M08	10	20

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

RunYearMonth	C17 Adoption	C10 Adoption
2020M07	66%	100%
2020M08	100%	33%

thanks!

[amitchandak]

@edayan , Try like

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

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

[AlB · Accepted solution]

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