Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |