Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, I have A problem.
I couldn't find any solution on this site Please help me.
I created a table by using summarize
Table_Summary = SUMMARIZE (
Table,
Table[tYear],
Table[Month],
Table[Level 1],
Table[Owner],
Table[Categoy]
"Adjusted Loss", SUM(Table[Adjusted Loss]),
"Total Order]",SUM(Table[Total Order]),
"Inefficient Order Qty",Sum(Table[Inefficient Order Qty]))
and I put this as a measure in the summary table
Measure =
VAR TEST1 = SUM('Table'[Adjusted Loss])/CALCULATE(SUM('Table'[Total Order]]])-Sum('Table'[Inefficient Order Qty]),ALL('Table'[Level 1],'Table'[Owner]))
RETURN IF (TEST1 = BLANK(),0,TEST1)
but it wasn't worked when I use this table in a matrix.
It didn't show any 0 results here is the result is there any solution
thank you and best regards
Sinan
Solved! Go to Solution.
@sinanalmac I recreated your file and matrix, everything in blue background color is new, you don't need to create a summary table to get you going. The updated pbix is attached.
I would 💖 Kudos 🙂 if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
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.
@sinanalmac try this
Measure =
VAR TEST1 = SUM('Table'[Adjusted Loss])/CALCULATE(SUM('Table'[Total Order]]])-Sum('Table'[Inefficient Order Qty]),ALL('Table'[Level 1],'Table'[Owner]))
+0
RETURN TEST1
I would 💖 Kudos 🙂 if my solution helped. If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
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.
thank you @parry2k
But I tried your solution but only it changed the results.
I'm trying to do this.
I just marked red to indicate. doesn't have to be red
@sinanalmac so what you are getting when added +0 ?? What do you see? Can you share the screen shot?
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.
@sinanalmac I see what is going on, your calculation is not actually returning blank() but it probably has values after the decimal, if you increase the decimal to 10 points and you will probably see some values, can you check it?
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.
hi, @parry2k thank you for your interest.
I have been working on this file for 3 hours.But I couldn't get any solution. I put the file in a dropbox folder. I wonder what I can't see
if you have time to look you can find the files in the link below
https://www.dropbox.com/sh/w4fuymtxiktwlpi/AACRx-JwF2QlVAocqj066qVZa?dl=0
Thank you
@sinanalmac I recreated your file and matrix, everything in blue background color is new, you don't need to create a summary table to get you going. The updated pbix is attached.
I would 💖 Kudos 🙂 if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
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.
Thank @parry2k you are a lifesaver.
Although I tried so hard, I could not find a solution. If you concentrate on one place, you cannot see the solutions in other places.(this is for me🙂)
If you have a request from Istanbul, please let me know. I would love to do it happily.
Best Regards
Sinan
User | Count |
---|---|
88 | |
73 | |
69 | |
64 | |
56 |
User | Count |
---|---|
98 | |
92 | |
84 | |
74 | |
66 |