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.
The following model has five tables, four with data and the last one is used as dynamic slicer.
CurrentStock:
ProviderID ProductID Stock
1 | 1 | 10 |
1 | 2 | 20 |
2 | 1 | 30 |
2 | 2 | 40 |
Product:
ProductID Description
1 | Product 1 |
2 | Product 2 |
Provider:
ProviderID Description
1 | Provider 1 |
2 | Provider 2 |
Sales:
ProviderID ProductID Quantity Date
1 | 1 | 5 | 01/01/2019 |
1 | 1 | 3 | 02/02/2019 |
1 | 2 | 10 | 01/01/2019 |
1 | 2 | 5 | 02/02/2019 |
2 | 1 | 15 | 01/01/2019 |
2 | 1 | 10 | 02/02/2019 |
2 | 2 | 20 | 01/01/2019 |
2 | 2 | 10 | 02/02/2019 |
Status:
Status
High |
Low |
Normal |
I created two four calculated measures:
RealStock = SUM(CurrentStock[Stock]) - SUM(Sales[Quantity])
OnlyStockProviderStatus = CALCULATE(IF([RealStock] > 9; "High"; IF([RealStock] < 4; "Low"; "Normal")); ALL('Product'[Description]))
Selected Status = VAR selected_value = SELECTEDVALUE('Status'[Status]) RETURN IF(ISBLANK(selected_value); "ALL"; selected_value)
ShowThisStatus = IF([Selected Status] = "ALL"; "SHOW"; IF([OnlyProviderStatus] = [Selected Status]; "SHOW"; BLANK()))
I have the two following visuals:
Since I just need to display the selected status, I created the follwing filter:
Now the problem occurs, since it is just a sample dataset I can not reproduce it, but on the orignal dataset I have a lot of providers and even more products. So if I filter the visual to not display blank values for ShowThisStatus, an error that my system does not have sufficient memory occurs. If I remove the product's description from the matrix it works withou problems:
Finally I want to know if it is possible to make the matrix visual "forget" its hierarchy and on only apply the filter to its root elements. If not, how can I make the filter "do not show blank values" to work?
Solved! Go to Solution.
Hi @Anonymous
Please check the workaround in this article to improve the memory.
Regards,
Cherie
Hi @Anonymous
You may try add a measure like below and use it in visual level filter.If it is not your case,please check the workaround in this article.
Measure = IF(NOT(ISBLANK([ShowThisStatus])),1)
Regards,
Cherie
Thanks, @v-cherch-msft , but it is not my case. The problem whem I activate the filter "Measure is not Blank" Power BI shows the memory error.
Hi @Anonymous
Please check the workaround in this article to improve the memory.
Regards,
Cherie
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |