The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I'm working on a report where values in the cards should be static when product filters are using and dynamic when non-product filters are used. I was able to bring in this with the help of interaction when we were using slicers. However, later it was decided to move to filter pane for using filters and interactions stopped working. I tried to bring in the similar functionality using ALLEXCEPT however, in a few scenarios where there are no values for a particular product it is giving blanks.
Values in the global summary should remain static and Business line should be dynamic.
I'm using the measure with DAX:
Origin Cases = CALCULATE(COUNTA(CaseData_OpenCases[CaseNumber]),ALLEXCEPT(CaseData_OpenCases,CaseData_OpenCases[CaseOrigin_Fixed]))
However, like I mentioned, for products where there are no related values in webchat or related segments, the static ones are also going blank. Each card has an additional origin filter to select the respective origin.
I need help in understanding what am I doing wrong here.
Also, is there a way to show 0 instead of (Blank)
I'm using the below dax for Business line cards:
Total Cases = COUNTROWS(CaseData_OpenCases)
Below are the filters I'm using in the report.
@Charinite , best way for "All" filter to work with all, it to have them in a separate table. So if you have a product group in a separate table, you can add all(ProductGroup[ProductGroup])
Also, refer if interactions can help
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Thank you for the suggestion. I'll try making another table and see if that helps. I'm trying to limit the number of tables in the model due to the data size.
I was using interactions earlier when we had slicers. Later slicers were removed and moved to filter pane and I couldn't use interactions with the filter pane.