Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have a calculated table made with SELECTCOLUMNS like this:
mySales = DISTINCT(SELECTCOLUMNS( Sales, "ProductID", Sales[ProductID], "Amount", Sales[Amount]) )
but it produces some blank values in Amount. How do I modify this table definition so that I get only rows that are non-blank in Amount column? I can not do this in M as this is a table derived from another table in Power BI.
Solved! Go to Solution.
May be this one
mySales = FILTER ( DISTINCT ( SELECTCOLUMNS ( Sales, "ProductID", Sales[ProductID], "Amount", Sales[Amount] ) ), NOT ( ISBLANK ( [Amount] ) ) )
May be this one
mySales = FILTER ( DISTINCT ( SELECTCOLUMNS ( Sales, "ProductID", Sales[ProductID], "Amount", Sales[Amount] ) ), NOT ( ISBLANK ( [Amount] ) ) )
Hi Bro,
Your reply was very usefull for me, I've made my table. Just a little more to add.
After making the custom table i just want to summarize one of the column, can you please help me on this.
Thank you so much.
Yep! Exactly. Clever solution.
Thanks!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
103 | |
99 | |
98 | |
38 | |
37 |
User | Count |
---|---|
151 | |
121 | |
73 | |
71 | |
63 |