Hi,
Is there a way to create/use a measure as a table. Let me explain by using an example:
I want to sort pictures in colour and Black&White. Instead of putting all the information in one measure like this:
ColorOrBW =
VAR
PictureTableGrouped = ADDCOLUMNS(
PictureTable,
"TypeOfPicture",
if(PictureTable[MainColour] in
{"black","grey","white"},
"BW",
"Colour")
RETURN
PictureTableGrouped
Bur instead of listing the colours (black, grey, white) within the measure I would rather have them as a separate measure, like this.
Measure with all the colours within one grup, like this:
Black_White = {"Black","Grey","White"}
...and then use this
ColorOrBW =
VAR
PictureTableGrouped = ADDCOLUMNS(
PictureTable,
"TypeOfPicture",
if(PictureTable[MainColour] in Black_White,
"BW",
"Colour")
RETURN
PictureTableGrouped
PS! I've tried to make the "table-measure" like this (but it did not work - could also be that I've did not use it correctly in the main measure (ColorOrBW). Here is how I made the "table-measure":
Black_White = DATATABLE("Black_White_Colours",STRING,{{"Black","Grey","White"}})
Thank you for all help in advance!
