Forum Discussion
[Question] Filtering columns in a matrix visual with DAX
- 1 year ago
Thank you! I managed to sort this out on my own. The issue was that one of the DAX commands should have been set to MIN instead of MAX—a silly mistake on my part, haha. Interestingly, I’m not sure why it worked when there were no fields in the rows. The corrected DAX formula is provided below:
year filter = VAR Selection = SELECTEDVALUE('Metrics'[Metrics]) VAR YearSelection = SELECTEDVALUE('Data release'[Year of data release]) VAR Mode = SELECTEDVALUE('STARTMODE'[Mode]) RETURN IF ( Selection = "A", IF ( Mode = "Part-time", IF ( MAX(YEAR[YEAR]) <= YearSelection - 4 && MIN(YEAR[YEAR]) >= YearSelection - 7, 1, 0 ), IF ( MAX(YEAR[YEAR]) <= YearSelection - 3 && MIN(YEAR[YEAR]) >= YearSelection - 6, 1, 0 ) ), IF ( Selection = "B", IF ( Mode = "Part-time", IF ( MAX(YEAR[YEAR]) <= YearSelection - 8 && MIN(YEAR[YEAR]) >= YearSelection - 11, 1, 0 ), IF ( MAX(YEAR[YEAR]) <= YearSelection - 6 && MIN(YEAR[YEAR]) >= YearSelection - 9, 1, 0 ) ), IF ( Selection = "C", IF ( MAX(YEAR[YEAR]) <= YearSelection - 3 && MIN(YEAR[YEAR]) >= YearSelection - 6, 1, 0 ) ) ) )
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
https://drive.google.com/file/d/1SUiO9VjnHY5a3svdI58ElI8tuhcmnz7n/view?usp=sharing
Thank you. I have uploaded the sample data. The output I expected is the sex table can filter the year based on the matrix and baseyear selected in the filter, similar to the table on the top.