Forum Discussion

shawn3474's avatar
shawn3474
Frequent Visitor
8 years ago
Solved

Having trouble recreating a visualization as a table.

  I am basically trying to recreate this visulation as a new table so I can work with the data:   Here is the problem I am having.   As you can see below, Small shows the number of total pro...
Need Help
  • MarkS's avatar
    MarkS
    8 years ago

    Hi shawn3474,

    Could you try

     Medium = CALCULATE(DISTINCTCOUNT(Table1[Project_Name]),[ProjectSizeValue] = "MED")

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

shawn3474,

If your table is as below, select ProjectSizeValue column, then click Pivot column in Query Editor to get your desired result.




Regards,
Lydia

shawn3474's avatar
shawn3474
Frequent Visitor
8 years ago

This is a new table I created from another table.  The data is not stored that way so a pivot on this won't work but thank you for the suggestion.