Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Charinite
Frequent Visitor

Need help in making card static

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.

 

Total Issue 1.PNG

Values in the global summary should remain static and Business line should be dynamic.Total Issue 2.PNG

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.

Filter.PNG

2 REPLIES 2
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors