Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
Hi @Anonymous
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
@Anonymous , Try like
C17 Volume Adopt % = divide(count(Table[C17 Volume]),countrows(Table))
C10 Volume Adopt % = divide(count(Table[C10 Volume]),countrows(Table))
Hi @Anonymous
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
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |