Calculate distinct of a table column plus two static values using DAX

Question

I have a tabular cube that I working on. I would like to get distinct values from "Column1" and then get two additional columns(to be created afresh) as static text one as "All" and other as "2020Q4".

Output would look like:

Column1	Column2	Column3
AA	All	2020Q4
BB	All	2020Q4
CC	All	2020Q4
DD	All	2020Q4
EE	All	2020Q4

Any help is appreciated. So far I am able to get distinct but unable to get associated static values.

score 2 · Answer 1 · answered Feb 09 '21 at 05:23

2

Your can simplify the code:

EVALUATE
ADDCOLUMNS (
    DISTINCT ( TableName[Column1] ),
    "Column2", "All",
    "Column3", "2020Q4"
)

answered Feb 09 '21 at 05:23

RADO

7,733
3
19
33

Thank you, yes it does look and function better! – ramadongre Feb 09 '21 at 17:44

score 0 · Answer 2 · answered Feb 09 '21 at 01:26

Finally able to do it as below:

 EVALUATE 
       Addcolumns( DISTINCT(Tblname[Column1]), "Column2", 
 SELECTCOLUMNS(Tblname, "Column2", SUBSTITUTE(Tblname[Column1], 
 Tblname[Column1], "All")),
 "Column3", SELECTCOLUMNS(Tblname, "Column3", SUBSTITUTE(Tblname[Column1], 
 Tblname[Column1], "2020Q4"))
 )

Calculate distinct of a table column plus two static values using DAX

2 Answers2