Store a table as measure

DaxCoffee — Tue, 06 Oct 2020 07:11:38 GMT

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!

Re: Store a table as measure

Anonymous — Tue, 06 Oct 2020 08:42:01 GMT

Simple answer: YOU CANNOT RETURN TABLES FROM MEASURES.

topic Re: Store a table as measure in DAX Commands and Tips

Store a table as measure

Re: Store a table as measure