Reusing measures in different tables
Hi, I’m a new BI user and this is my second post. I have 10 tables total (see the breakdown below) and have provided the tables with active relationships. My question: what do I need to so that the measures found in tables E-G can be used by other tables, specifically by tables A-D when I build my visualizations? Is it possible to extract the measures found in tables E-G to create a new table and this new will have an active relationship with tables A-D? I cannot make any of the current relationships inactive. Thank you in advance for any guidance/assistance provided. Table A – active relationship with Table E via ID Table B – active relationship with Table E via ID Table C – active relationship with Table E via ID Table D – active relationship with Table E via Name Table E – active relationship with Table C via ID and with Table G via Name (Table E has a max date formula, a conditional column, and a measure) Table F – active relationship with Table B via Name (Table F has a max date formula, a conditional column, and a measure) Table G – table has a max date formula, a conditional column, and a measure Table H – active relationship with Table G via ID Table I - active relationship with Table G via ID Table J - active relationship with Table G via ID
Measure to group and calculate totals
Hi everyone, I have 3 tables in my Data Model: one with the Sales value, one with the type of product, and another one with the country name. The Sales table is linked to the product table and the country table with a many to one relationship (where many is my Sales Table) I need to do a pretty complex calculation here: I would like to have, for each type of product, the total by country. Then, to have the weight of each country, i would like to divide this total by product type and by country by the total for each type of product. I don't wan't to create a new table, and I was wondering if I can create a measure, which would take into account the selected product type and country and automatically do the calculation when I analyze the data... I hope I have been clear enough 🙂 Thanks you very much to everyone, ElviCumulative Total Comparison between 2 years on Line chart
I am using a measure to calculate Cumulative Spend within a year, so 2018 should appear as a separate line and 2019 as a separate line. Cumulative Spend Previous Yr (M) = CALCULATE( SUM('Concur Report'[Expense Amount])/1000000, FILTER( ALLSELECTED('Concur Report'), 'Concur Report'[Transaction Date]<=MAX('Concur Report'[Transaction Date]) &&YEAR('Concur Report'[Transaction Date])=[Previous Year] ) ) (Another similar measure for Current year) However, please take a look at the results: I am getting this peculiar result on the 2nd image, where i want to compare cumulative 2019 vs 2018
