User Profile
plew
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
Why would a simple filter not work?
I can't understand how something as basic a filtering go this wrong, but it apparently doesn't work in my current case. Can someone see a reason? I filter Table visual by "Category ID" field. I want to unfilter several Category IDs from the data. When I unselect the first one, it disappears as it should. However, when I unselect a second value, the filter stops working. Values unselected in the filter appear in the table, as seen below: Interestingly, when I invert the filter and select one or many of Category IDs, the table returns empty. I tried using the "Category ID" as a proper dimension in star-schema model and as an element of the fact table - neither has worked. The other column is a DAX measure "Value" - a simple SUM of amounts from fact table.COLLAPSEALL not working for smaller numbers in a Visual Calculation
I've been trying to write a visual calculation formula, but I've noticed that for smaller numbers it doesn't work as expected. I've been able to pin the problem to COLLAPSEALL behavior. It basically stops working for smaller numbers in my table. It works well for many rows, but when it reaches values smaller than 0.01% of the column total, the Total column shows the row value, instead of the expected Total value (collapsed column total). The test formula is as simple as this: Total = COLLAPSEALL([Value],ROWS) The screenshot shows a data sample, where it breaks (rows sorted by value, descending).Appending data from external semantic model
I need to append data from 2 sources: Excel file data imported with PowerQuery Data from an external semantic model from a published PowerBI report. When I connect to this one, it only exists as a live connection in my PowerBI file, not as a Query though. The option to append tables is only available in the PowerQuery editor. But the data coming from the conection to external semantic model is not visible there. How can I append these two? View in the main PowerBI window: View in the "Transform Data" editor (data from external semantic model not visible): Append wizard view (data from external semantic model not available):
