Forum Discussion
How to remove summarize function for measures in Table visualization?
It is not recommended to use bi-directional many-to-many relationships in your model. We will use it but will mark it as inactive. (uncheck Make this relathioship active)
Create the calculated column as follows:
LineTotal USD = [LineTotal] * CALCULATE ( TOPN ( 1, VALUES ( viewBBeImInvoice_GLReport[ExchangeRate] ) ), USERELATIONSHIP ( viewBBeImInvoice_GLReport[InvoiceGuid], viewBBeImInvoicePosition_GLReport[InvoiceGuid] ) )assuming that exchange rate is repeated for the same invoice.
You can control the displayed values by the measure itself.
Share more details on your model and the measure you want to modify.
I have a couple of questions:
What is your table structure?
What is the desired output?
What do you mean with line item?... do you mean each table row? or aggregated GL?
Hi,
I have two tables mainly:
1) invoice header level, where each line is each invoice
2) invoice line item level, where each line is each line item within each invoice, so you can imagine this table to be way bigger.
Relationship between the 2 tables have been setup to link via invoice number.
Table 2) is what I am working on, but that table only has line item value at local currency. I need to convert to USD but this table doesn't have the exchange rate. Exchange rate only exists in Table 1). Hence I wrote that DAX measure to bring in the exchange rate for the corresponding invoice.
I do not need to summarize any columns of data as I want to display it as is. Hope this explains.
I think the issue is that you are using a measure while it is better to use a calculated column.
Create a calculated column in Table 2 as follows:
LineTotal USD = [LineTotal] * RELATED ( Table1[ExchangeRate] )