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 three columns, as shown in the image. When I added the 3rd column, the rows got duplicated. Why is that? How do I prevent it? You can see the formula for the 3rd column. It is just a hard coded value. It's just a placeholder for now. But there should only be two rows, not four. What's going on here?
Solved! Go to Solution.
Yes, I have many tables in the model, but these columns are all coming from the same table.
As an experiment, I tried re-creating Pipeline Coverage Ratio as a Measure (Same formula), and it worked as expected. It shows just 2 rows now, with "N/A" is each row. Go figure.
Thanks for your help.
Interesting!!
Just curious, if you remove this "Pipeline Coverage Ratio", do you get two rows?
Are there multiple table ? If yes, how those are related?
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.
Yes, if I remove Pipeline Coverage Ratio, the table collapses to two rows. It's weird. All columns are coming from the same table.
This is very bizzare.
How about if you don't use count and put all three columns, you except to see table with N/A for each row. Basically try to find out if there will be a case when this field has blank value instead of N/A
On other note, so you are saying your model has only one table or you have more than table and they have relationship, regardless even if you are showing columns from one table. Just trying to understand the problem here, very interesting.
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.
Yes, I have many tables in the model, but these columns are all coming from the same table.
As an experiment, I tried re-creating Pipeline Coverage Ratio as a Measure (Same formula), and it worked as expected. It shows just 2 rows now, with "N/A" is each row. Go figure.
Thanks for your help.
Very interesting, as you confirmed that data is coming from same tables, not sure why it wouldn't work if you added as a column.
Surely relationship with other column has something to do with it, cannot comment until I see the setup.
Anyhow, glad it is working, will leave it here for now..
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.
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |