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.
Hello,
I'm using a function to group and filter a raw table, but the fields who are filtered out are actually still there. I can see them in the filter pane of PowerBi where I can deselect "empty" fields. But it would be more beneficial to get rid of them already in the function:
I have also encountered such problems. I will check the value of the field in the query editor and replace the null value with null.
Hi @Applicable88 ,
I think you can use the following measure for the calculated table:
Summarized =
FILTER (
ADDCOLUMNS (
SUMMARIZE (
Table,
Table[Date],
Table[Material],
Table[TotalAmount]),
"SummeRest", CALCULATE ( SUM ( Table[Reserve] ) )
),
Table[Material] <> BLANK()
)
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
The blanks might be coming from the relationship between the tables, https://excelwithallison.blogspot.com/2020/07/what-does-this-blank-mean.html
Which field in the filter pane has the 'empty' values that you're filtering out?
Why do you need to create a calculated table for this? It's helpful to understand the final requirement as there may be another way to solve the issue.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |