Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi everyone,
i'm quite new in Power BI and i'm learning DAX from scratch, so this issue may be very simple or implossible to solve… Hope this lines gives you a right overview of what I'm searching for.
I'm trying to create a matrix that displays the revenue and number of TEU booked by client, for a certain voyage.
I'm ok about what's up to Revenue/client, as that information is stored on the same data table…
The problem comes when connecting TEU/Client by voyage… As you see in the image, the table returns the right number of TEU for that voyage, but repeats the value on every row…
TeuCliente = CALCULATE(SUM('dba v_sales_statistic_list'[sst_teu]);
FILTER(Table3;Table3[Group Sort]=10);
FILTER('dba sa_voucher2_pos';'dba sa_voucher2_pos'[vo2_service]= "9159");
FILTER('dba v_sales_statistic_list';'dba v_sales_statistic_list'[Category]="Inter-Ilhas Cheios");
FILTER('dba sa_voucher2_pos'; 'dba sa_voucher2_pos'[vo2_rmanr]=RELATED('dba reise'[rermanr]))
)
This is the expression I'm working on now… I need the sum of TEU, stored on dba v_sales_statistic_list. Clients name info are based on a table called "Voucher1_head". This table isn't directly connected to "dba v_sales_statistic_list". Instead, it is connected to a table called "voucher2_pos" (by a field called "vounr"), which is connected to "dba v_sales_statistic_list" by a field called "manr".
Do you think that, with this data tables and the connections between them, it is possible to obtain the TEU/client discriminated?
Thank you very much,
Sofia
Hi @Anonymous
You need to provide more details on your data model, otherwise it is very tough to respond.
I see you have confidentiality issues with your data but this should be fine:
1. Please show a view of the tables and relationships in your model. Go to the relationships pane/view and take a screen capture. Make sure it can be read and if necessary add to this a written description of the relationships.
2. Show the structure of your tables. To avoid confidentiality issues you can just show one row (with dummy data if necessary) but at least show the names of the columns so that we can have an idea of which fields go where.
3. Try to explain a bit more what you need. It is not completely clear. Maybe it's a good idea to explain it through an example based on your data.
That's regarding the missing info.
What I can answer now is that if you do not have relationships there won't be filtering. For example, what is Table3 and what are its relationships? If it's not related to 'dba v_sales_statistic_list' in some way, the FILTER( ) you have on it will have no effect on your measure.
Hi @AlB
Thank you for your message yesterday.
You can see attached the data table relationships for the tables I'm using.
I've noticed that the expression I was working on had some filters that i don't actually need.
TeuCliente = CALCULATE(SUM('dba v_sales_statistic_list'[sst_teu]);
FILTER('dba v_sales_statistic_list';'dba v_sales_statistic_list'[Category]="Inter-Ilhas Cheios")
)
An expression with this filter should be enough…
I need info that is stored in dba v_sales_statistic_list [sst_teu] by customer. Customers info are stored in dba sa_voucher1_head [vo1_custmatchcode].
On the image bellow I've tried to display the table as i wanted.
Thank you for you help and attention.
Sofia
Hi @Anonymous
I'm quite lost. I'm missing a lot of info and find it very hard to help. You say: I'm ok about what's up to Revenue/client, as that information is stored on the same data table…
In what table? Can you show how you do that? It might help me understand some things. I don't see any revenue fields in the tables shown. Additionally, where is the Category field that you want to use for filtering?? I do not see it on the table
This is really a shot in the dark as there's a lot of info I am lacking but if you place the customers in the rows of the matrix, you could try with this measure:
MeasureTeuCliente = CALCULATE ( SUM ( 'dba v_sales_statistic_list'[sst_teu] ); 'dba v_sales_statistic_list'[Category] = "Inter-Ilhas Cheios"; 'dba sa_voucher2_pos' )
in which we are making use of the expanded table of 'dba sa_voucher2_pos'. Like I said, a shot in the dark but maybe it can be of some help. Here and here you can find two interesting articles on expanded tables.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
55 | |
54 | |
38 | |
29 |
User | Count |
---|---|
78 | |
62 | |
45 | |
40 | |
40 |