Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@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.
I cant attached .xlsx file.
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.
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |