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.
PCode PNAME VALUE VC
CE ABC 100 XX
CE ABC 100
XY MNO 200 YY
XM PQR 100 ZZ
I want total sum for VALUE column it should only sum values for unique PCode,PName and Value combination like it should only sum CE ABC 100 only one time as it is duplicated, VALUE column is coming from table2 and Pcode and PNAme is coming from table1
Hi @MahiK
PTable
Output: 600
Formula:
Try and see if it works for you. If yes could you please mark it as a solution and give a kudo 🙂
Thanks but The value column is coming from different table so in summarize we can not have all three columns which is causing the issue
Assuming you are retrieving values based on PCode matching in both tables, if so merging (Left Outer Join) should work and can summarize with the values. If not let me know in what condition the "values" will be fetched.
Hi @MahiK ,
You could use a measure something like this:
_sum_PCode_PName_Value =
SUMX(
yourTable,
MAX(yourTable[Value])
)
You'd need to make sure you use it with the correct dimensions in a visual, otherwise it may give unexpected results.
Pete
Proud to be a Datanaut!
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.