Forum Discussion
Adding additional record as in Drop down selection/Filter Selection.
Hi Team,
PF details below :
Name | Product | Analyst |
AA | sdfgsdfZZZ |
|
BB | fer34r45y5 |
|
CC | jhjyjhh ZZZ |
|
AA | ggrgr |
|
BB | Not |
|
FD | gora ZZZ |
|
HE | only is |
|
HE | HOEEZZZ |
|
BD | gfgrg |
|
I have created Dax –
Analyst = SWITCH(TRUE(),CONTAINSSTRING(Sheet1[Product],"ZZZ"),"IN",Sheet1[Name] IN {"AA","BB","HE"},"OUT",BLANK())
In Analyst Columns I need additional record as “COMPLTAED” ,”IN PROGESS”,”STOP” as Drop down selection/Filter Selection.
How we can add “COMPLTAED” ,”IN PROGESS”, ”STOP” in data in Analyst Columns.
Thanks & Regards,
Rakesh Jadhav
6 Replies
Hi Rakesh,
Just expand your DAX to include the extra statuses by adding more conditions to your SWITCH, or if you want them as fixed filter options without changing your data, create a separate calculated table with all possible statuses and use that as your slicer. That way your Analyst column stays as is but the filter still works.
Best regards,
DanieleHi Rakesk13
You cannot add an extra rows to an existing table unless you actually append those rows to a table or created a calculated table that takes the distinct values of analyst column and unioned with those extra rows. Or you can simply create a calculated table with all the needed values that is separate from sheet1.
Please see the attached pbix.
Hi ,
Its really Thanks for such quick reply,
But in Analyst Columns i am unable to get “COMPLTAED” ,”IN PROGESS”, ”STOP" filter selection for export of data. i am looking for “COMPLTAED” ,”IN PROGESS”, ”STOP" data in same Analyst Column.
Please let me know how it will work.
Its really appreciate foir quick reply.
Thanks
Rakesh Jadhav
As mentioned, you cannot add additional records to a table that contains calculated columns because calculated columns are restricted to the rows already present in the table.
You have two options. You can create a calculated table that combines the original table with the additional rows using UNION. Keep in mind that both tables must have the same number of columns, and the columns must be in the correct order when UNION is performed for the first time. The append is based on column position, not column names.
Alternatively, you can perform the append in Power Query, which is generally the preferred approach when you need to add additional records to the source data.
Hi Rakesk13
Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.
Hi Rakesk13
Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.
