User Profile
tragonneau
Frequent Visitor
Joined 9 years ago
User Widgets
Contributions
Related table - Calculated column
Hello, I use DirectQuery. I am working with two tables, let's say Table1 and Table2 for exemple : The relation between these 2 tables is : Table2[id] (many)=>(one) Table1[id] I wanted to create a calculated column like this : CalculatedColumn = IF(RELATED(Table1[deal_type]) = "Sell";Table2[sell_destination];Table2[buy_destination]) To have a result like this : But it seems I can't use RELATED in calculated columns in DirectQuery. Also, using RELATED in measures causes me this error : 'The column xxx either doesn't exist or doesn't have a relationship to any table available in the current context'. I feel a bit lost because I think this problem is easy to solve but I can't find a way to do it... I would be happy to have some help.Re: Problem with cumulation total when adding filters
blopez11 Thanks, it works well with the DateTable. I don't know why i didn't use it. v-qiuyu-msft Thanks, but it's not what i wanted to do. My explanations were confusing, i'm sorry. Maybe it will make more sense with the following screenshot. I wanted to see the values for a shorter period : the top side chart represents the values in the red rectangle.Problem with cumulation total when adding filters
Hello, I have the following table : I have created this measure to have the cumulative total of the Qty : qty_cumul = CALCULATE( SUM(Stock[Qty]); FILTER( ALL(Stock[date]); Stock[date] <= MAX(Stock[date]) ) ) It works as I want. When I want to see the evolution of the cumulative total for specific entities (let's say ENT_1 and ENT_2), it still works well. HOWEVER i have a problem when I add a visual filter to see the evolution of the total for a specific period. The result is not the sum of the cumulative quantity of ENT_1 and ENT_2 (whereas it is when i don't use the filter on the date). I realised this graph is displaying alternatively the cumulative total of ENT_1 and ENT_2 which is not what I want. When I added the filter on the date i expected my bottom chart to be a "zoom in" of the top chart. I don't understand why it doesn't work as I want. I feel like I am missing something. Can you help me please. I am working in DirectQuery mode but to explain my issue i created a custom table. Here the file i used to do the screenshots: https://www.dropbox.com/s/sekh8g8ht03ibbs/StockCumulativeTotal.pbix?dl=0
