Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |