How to calculate percentage of customers for different market segment

[Anirban_25]

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?

[tenfingers]

Business Type % =
DIVIDE (
    DISTINCTCOUNT ( Table[Customer ID] ),
    CALCULATE (
        DISTINCTCOUNT ( Table[Customer ID] ),
        REMOVEFILTERS ( Table[Business Type] )
    )
)

[darentengmfs · Accepted 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.

[Anirban_25]

Thank You!