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.
I have DocumentID, LineNo and Amount as columns.
I want to sum all DocumentID's Amount that have a specific expression on LineNo. The result from the picture should be the sum of blue values, because only does DocumentIDs have "test1" on LineNo.
Solved! Go to Solution.
Aha, then try this:
I used some simplified data like below:
makes sense?
No, this measure will sum only rows with "test1". This will sum only green rows, I need to sum blue rows.
try to create a measure with the code below:
This is just a sample. I have millions of documents and I don't know which one of them has "test1" on LineNo.
Aha, then try this:
I used some simplified data like below:
It works! Thank you!
Only in the last chat, came I to understand your expection. The requirement clarification is soooo important.
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 |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |