Hello,
I have a matrix that is made up strictly of measures, and I want to conditional format some of the values, I am just not sure how to do it.
I have a table that is set up with only one column and the following rows:
| Type |
| # of Sales |
| $ of Sales |
| % of Sales |
From there, I created measures for each of my categories, since some of my categories are Stores, some are specific products, and some are types of products.
An example of my measures are:
Location A =
IF(
MIN('Table'[Type]) = "# of Sales", CALCULATE(COUNT('Data Table'[Tran ID), FILTER('Data Table', [Location] = "Location A")),
IF(
MIN('Table'[Type]) = "$ of Sales", FORMAT(CALCULATE(SUM('Data Table'[Tran Amt]), FILTER('Data Table', [Location] = "Location A")),"$#,##0"),
IF(
MIN('Table'[Type]) = "% of Sales", FORMAT(DIVIDE(CALCULATE(SUM('Data Table'[Tran Amt]), FILTER('Data Table', [Location] = "Location A")), [TOTAL SALES AMOUNT]), "#0.#%"))))
the only difference between my measures is the filters that are placed on them in the calculations.
My end Matrix looks like this:
| Calculation | # of Sales | $ of Sales | % of Sales |
| Location A | 125 | $1250 | 25% |
| Product Z | 50 | $800 | 15% |
Where my Columns are the three values for Type, and the Values are all of my created measures, but I selected the "Switch Values to rows" option in my matrix to make it appear as a table.
Is it possible to format only one of the columns if they are all conditional measures? Also as a side question, is there a better way to calculate this table? Thank you in advance!
