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")

     

     

MarkS's avatar
MarkS
Resolver IV
8 years ago

Hi shawn3474,

Could you try

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

 

 

shawn3474's avatar
shawn3474
Frequent Visitor
8 years ago

Mark...This worked.!!!!   Thank you very much for the help!  This created a circular dependency which I fixed by adjusting the table relationships.  I am good to go now.