Marketshare DAX

[IgorAM]

Hi guys,

I have two table, the first one with some data from sales on country (columns: client__id, product_category, value), and another with clients_id (my clients) from a region (every client_id in this table is in the first table). What I need a marketshare by category in percentage. For example:

Category	Country sales	My clients	Marketshare (%)
A	150000	70000	70000/150000 = 46,6%
B	100000	37000	37%
C	275000	68000	24,7%

I related this two tables using client_id, but now, I dont know how to make the dax measure.

[Greg_Deckler]

@IgorAM Can't be sure without sample data but can you do this?

Measure =
  VAR __Country = SUM('Table1'[Country])
  VAR __Clients = SUM('Table2'[My clients])
  VAR __Result = DIVIDE( __Clients, __Country, 0 )
RETURN
  __Result

Otherwise, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[IgorAM]

I cant attached .xlsx file.

[IgorAM]

Try this link https://docs.google.com/spreadsheets/d/1PjTsM3VyJEdy_2Sss6y7MdyCV3brKBDV/edit?usp=sharing&ouid=10164...

there is two sheets withs table and the result that I need.