cancel
Showing results for
Did you mean:
Frequent Visitor

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*..

thanks!

1 ACCEPTED SOLUTION
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

2 REPLIES 2
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))

Proud to be a Super User!

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

Announcements

#### Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks