Forum Discussion
DAX - Count Distinct - Filtering with Numeric Parameter on 2 visuals
HI Specialist707,
#1, These zero value records are really stored in your table, you can set a filter to exclude them, but these row/column will keep displayed on the matrix excepted full row/column has blank values.(power bi will auto hide the row or column with blank values)
#2, It sounds like you want to filter on the summary value instead of detail records. For this scenario, I'd like to suggest you modify your formula to add a variable to summary table records at first, then you can check the current category and summarize variable table values to filter records.
All the secrets of SUMMARIZE - SQLBI
#3, You can modify the above formula with selectedvalue to interaction with what if parameter.
Use what-if parameters to visualize variables - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
HI Specialist707,
#1, These zero value records are really stored in your table, you can set a filter to exclude them, but these row/column will keep displayed on the matrix excepted full row/column has blank values.(power bi will auto hide the row or column with blank values)
#2, It sounds like you want to filter on the summary value instead of detail records. For this scenario, I'd like to suggest you modify your formula to add a variable to summary table records at first, then you can check the current category and summarize variable table values to filter records.
All the secrets of SUMMARIZE - SQLBI
#3, You can modify the above formula with selectedvalue to interaction with what if parameter.
Use what-if parameters to visualize variables - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng