Forum Discussion
Helper IAggregate and calculate two different columns
Hi,
You can easily add other new custom category to the original formula by IF function, like this:
New_Category = IF ( 'Table'[Category] IN { "Hi-Energy GNA 98", "SPB95 Hi-Energy", "SPB98 Hi-Energy" }, "Petrol", IF ( 'Table'[Category] IN { "A", "B", "C" }, "Gas", 'Table'[Category] ) )Best Regards,
Giotto
Community ChampionHi MigWare
see this technique
https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning
Helper IHi,
That option is not available, greyed out. Any other ideia?
- v-gizhi-msft
Community Support
Hi,
Please try to create this calculated column:
New_Category = IF ( 'Table'[Category] IN { "Hi-Energy GNA 98", "SPB95 Hi-Energy", "SPB98 Hi-Energy" }, "Petrol", 'Table'[Category] )Then choose this new category column as Legend field, the result shows:
See my attached pbix file.
Best Regards,
Giotto
- MigWare
Hi,
Thanks for providing that solution, however when I change the table fields to match my data I´m getting the following error:
A single value for column 'Product Description' in table 'Master' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
- v-gizhi-msft
Hi,
Please try to create a calculated column rather than a measure.
Please check my previous reply again.
Thanks!
Best Regards,
Giotto