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.
Hello Guys
First time here, first of all I'm sorry that English is not my native language. I am trying to make a sum of a column only when my product is a "lançamento" in the lançamento column. The example below:
MAT Atual -1 | MAT Atual | Lançamento |
1 | 1 | Lançamento |
1 | 2 | Lançamento |
3 | 4 | Maduro |
5 | 6 | maduro |
7 | 8 | Lançamento |
7 | 8 | maduro |
MAT Atual -1 lançamentos | MAT Atual lançamentos | |
9 | 11 |
I'm using the following formula: Soma lanç = SUMX(VALUES(OUTUBRO[Lançamentos]);OUTUBRO[Soma Mat Atual])
But does it sum only what is being filtered in the report and not just the "lançamentos" in that column could help with a new formula?
Thanks so much
Solved! Go to Solution.
Add a measure as below, change column name and table name as per your data table.
Sum of Lancamento = Calculate( Sum(Table[MAT Atual]), Filter( AllSelected(Table), Table[Lancamento] = "Lancamento" ) )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Add a measure as below, change column name and table name as per your data table.
Sum of Lancamento = Calculate( Sum(Table[MAT Atual]), Filter( AllSelected(Table), Table[Lancamento] = "Lancamento" ) )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thanks! It worked!
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 |