Thanks for contributing an answer to Stack Overflow! Finally, consider that because the DAX filter is applied to the key column, if you use ISFILTERED, the column to check is the column specified in Group By Columns and not the column shown in the slicer. You can get there with old-school time intelligence measures (and some patience). Hi @Max , did the response provided by @Harsh help you solve your query? Keep me informed about BI news and upcoming articles with a bi-weekly newsletter (uncheck if you prefer to proceed without signing up for the newsletter), Send me SQLBI promotions (only 1 or 2 emails per year). And the first surprise is that ALL works! At last we can create two measures and add them to Values. Group Type: List ( group) or bin. This is how to group columns and show the grouped data in the Power BI matrix. Like the two previous scripts used in this post, this one is also one-click compliant, so save it as a macro or custom action, and if youre in TE3 put it in your macro toolbar, totally worth it. This is what i want: But with Power BI desktop the result is: Is there a way to group measures like in the first image? Use Measures in Columns of a Matrix Visual - Goodly It is clear we need to be able to select combinations of base measure + calculation, and the best way to do that is with measures. Then we can create a matrix table using this table. In Tabular Editor, select the column City (unique) (1) in the Customer table, select the button to open the Choose Column dialog box in the Group By Columns property (2), select both Customer[Country] and Customer[State] in the Choose Column dialog box (3) by holding down the CTRL key as you click the two columns, and click OK (4) to close the Choose Column dialog box. In order to keep a single demo file, we duplicated the City column into City (unique). we should add logic to get the correct format string at this point I realized I was going down the wrong rabbit hole. Let us see how we can display the matrix visual with Multiple columns in Power BI. This will allow you to use them to slice data as matrix rows; Total Units is a useless column because we can easily reproduce it with DAX measure, and then it will be dynamic (it will respond to matrix rows, columns, slicers and other interactive controls); But its not. In power bi is not easy to define arbitrary 2 level column headers in a matrix visual. Finally, Calculation Groups and their associated Calculation Items cannot be added or edited using Power BI Desktop. Ok sorry, lets go back to the script to create measure groups. Now, for the dynamic measure calc items well do some tuning. And dynamic measure calc groups applies the format string of the original measure. Excel chooses the safe route of stopping users from looking at wrong data, which is good this was not happening with the Keep Unique Rows property. Go to Solution. just use the same approach including all the calc items that should display underneath might be a bit nasty to maintain if there are many changes, but in theory it should work. Right now the measures are being dragged independently under the Values section which is being applied to both the scenarios i.e. This is because neither TREATAS nor a CALCULATE filter condition can specify City (unique) without also specifying Country and State: The issue with the DAX syntax is that the three columns City (unique), Country, and State must be part of the same table.
