Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
I have some data and I want to sum 'Translated Ampount' based on 'revenue Category' column and then be able to map it with the customer. PLease let me know how can I do that. Apprecaite any help.
Thanks
Solved! Go to Solution.
HI @aggarwal25,
You can take a look at below formulas if it suitable for your requirement:
Calculate column:
Sum Group = CALCULATE(SUM('Table'[Translated Ampount]),FILTER(ALL('Table'),[Revenue Catagory]=EARLIER('Table'[Revenue Catagory])) )
Measure:
Sum group 2 = var catagory=LASTNONBLANK('Table'[Revenue Catagory],[Revenue Catagory]) return CALCULATE(SUM('Table'[Translated Ampount]),FILTER(ALL('Table'),[Revenue Catagory]=catagory))
Regards,
Xiaoxin Sheng
Hi all
I have this data and I want to sum "Total Qty Per Request" based on the "Material Name." So I want the sum of the "Total Qty Per Request" for "Bot Bev G5," "Dexron LS Gear Oil 75W-90," etc. How would I be able to make a measure for this?
I have the same question about how to sum a column based on another column and cannot get a solution using the result provided. The "EARLIER" command isn't understood in my expression. Got any tips?
HI @aggarwal25,
You can take a look at below formulas if it suitable for your requirement:
Calculate column:
Sum Group = CALCULATE(SUM('Table'[Translated Ampount]),FILTER(ALL('Table'),[Revenue Catagory]=EARLIER('Table'[Revenue Catagory])) )
Measure:
Sum group 2 = var catagory=LASTNONBLANK('Table'[Revenue Catagory],[Revenue Catagory]) return CALCULATE(SUM('Table'[Translated Ampount]),FILTER(ALL('Table'),[Revenue Catagory]=catagory))
Regards,
Xiaoxin Sheng
@Hi @aggarwal2,
Is there a customer in this table or is there a related table that contains customer? 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. Also you could create several measures that sum the different revenue categories like:
Consulting Revenue = SUMX ( FILTER ( Table1; Table1[Revenue Category] = "Consulting" ); Table1[Translated Amount] )
If there is no customer table related to this table or no customer in this table, how would you assign a part of the Translated amount to a customer? So what is the distribution key?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |