Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am very new to this tool and what I want to do is, find the % of customers per business type. How to create this Measure?
Solved! Go to Solution.
Hi @Anirban_25
I am assuming Customer ID is the % you want from.
You can just select the visual, click the dropdown on your column, and show value as Percent of grand total.
Business Type % =
DIVIDE (
DISTINCTCOUNT ( Table[Customer ID] ),
CALCULATE (
DISTINCTCOUNT ( Table[Customer ID] ),
REMOVEFILTERS ( Table[Business Type] )
)
)
Hi @Anirban_25
I am assuming Customer ID is the % you want from.
You can just select the visual, click the dropdown on your column, and show value as Percent of grand total.
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |