Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anirban_25
Regular Visitor

How to calculate percentage of customers for different market segment

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?

 

Capture.PNG

1 ACCEPTED SOLUTION
darentengmfs
Post Prodigy
Post Prodigy

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.

 

darentengmfs_0-1600466575983.png

 

View solution in original post

3 REPLIES 3
tenfingers
Advocate II
Advocate II

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

darentengmfs
Post Prodigy
Post Prodigy

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.

 

darentengmfs_0-1600466575983.png

 

Thank You!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.