Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
77 | |
76 | |
44 | |
30 | |
26 |
User | Count |
---|---|
97 | |
91 | |
52 | |
47 | |
46 |