Try to concatenate 1st the columns and use the concatenate column in measure. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. I want to be able to SUM sales per customer, per week, I want my table to look like this afterwards. The largest, in-person gathering of Microsoft engineers and community in the world is happening April 30-May 5. Passing negative parameters to a wolframscript. Does the order of validations and MAC with clear text matter? Find out about what's going on in Power BI by reading blogs written by community members and product staff. . If you only have these columns, you can do this. Write this measure, =CALCULATE(SUM(Data[Sale]),ALL(Data[Week]). Content Discovery initiative April 13 update: Related questions using a Review our technical responses for the 2023 Developer Survey, Power Query: Replace Value based on other column, Trying to return the maximum value of a filtered date column in Power BI, How to note if an indicated action has any future actions occur after it in Power BI. If you only have these columns, you can do this Total = CALCULATE ( SUM ( Table1 [Sales] ), ALL ( Table1 [Sales] ) ) By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. Not the answer you're looking for? Calculate two columns with the average of one and the sum of another By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. Sum of values based on distinct values in other column - Power BI Is there a generic term for these trajectories? Solved: Sum value based on another column - Microsoft Power BI Community Microsoft Power BI Community Forums Get Help with Power BI Desktop Sum value based on another column Reply Topic Options beekee Helper IV Sum value based on another column 11-21-2020 07:51 PM Hi All, I have two tables (Table 1, Table 2). Also you could create several measures that sum the different revenue categories like: If there is no customertable related to this table or no customer in this table, how would you assign a part of the Translated amount to a customer? Find out more about the April 2023 update. Do you know if you wan the calculation as a column or measure? By default, Power BI creates a chart that sums the units sold (drag the measure into the Value well) for each product (drag the category into the Axis well). (Ep. If this is the case you can easily drag and drop customer, translated amount an revenue category onto the Power BI desktop canvas and it works. Sum: Column operation: Sums up all values from a column . To subscribe to this RSS feed, copy and paste this URL into your RSS reader. Click here for a hack to quickly replace it with your own table names, How to Get Your Question Answered Quickly. Folder's list view has different sized fonts in different folders. Should I re-do this cinched PEX connection? Browse other questions tagged, Where developers & technologists share private knowledge with coworkers, Reach developers & technologists worldwide.
Metallica Russia 1991 Deaths, Articles P