Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a table

Hello everybody, I have a table in Power BI and I have created the following visualization. As you can see there 6893 articles, some of them are only C (Costruction), some of them are only I (Industr...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Based on your description, you can create a calculated table as follows.

    My test table:

     

    Table =

    var x1=SUMMARIZE('Sheet4',Sheet4[cod_art],"count",DISTINCTCOUNT('Sheet4'[Column]))

    return

    ADDCOLUMNS(x1,"category",IF([count]=2,"Mixt","Only"&" "&LOOKUPVALUE('Sheet4'[Column],Sheet4[cod_art],[cod_art])))

     

    Result:

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

iXpert_info's avatar
iXpert_info
Helper II
5 years ago
Hey Anonymous 

You can create a calculated column with below formula

Column = IF('Table (4)'[C]=1,IF('Table (4)'[I]=1,"Mixt","C"),"I")
 
Did I answer your question? Please mark this as solution

Best Regards
Jay Patel
iXpert Analytics