Forum Discussion

klittle95's avatar
klittle95
Regular Visitor
7 years ago
Solved

visualization table will only use unique values

I'm fairly new to Power BI, so it's entirely possible the solution to this is staring me in the face, but I've been working on it since yesterday and I'm out of ideas. I'm trying to calculate how mu...
  • klittle95's avatar
    klittle95
    7 years ago

    You were on the right track--the working code:

    Working Price = CALCULATE (  SUMX('ProceduresHistory-1', Related(ProceduresDetails[PD-Price])))
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi klittle95,

 

Please try to add below measure into table visual together with date field.

Sum Price =
CALCULATE (
    SUM ( Table1[T3-price] ),
    USERELATIONSHIP ( Table1[ProcedureID], Table2[ProcedureID] )
)


Regards,

Yuliana Gu

  • klittle95's avatar
    klittle95
    Regular Visitor
    7 years ago

    Hi v-yulgu-msft,

     

    I created 

    Sum Price = 
CALCULATE (
    SUM ( Table3[T3-price] ),
    USERELATIONSHIP ( Table3[ProcedureID], Table4[ProcedureID] )
)

    inside Table3 and added it to each table visual. In every case, it produces the same numbers as Table3[T3-Price] did. 

    The same thing happens if I create the measure inside Table4.

    • klittle95's avatar
      klittle95
      Regular Visitor
      7 years ago

      You were on the right track--the working code:

      Working Price = CALCULATE (  SUMX('ProceduresHistory-1', Related(ProceduresDetails[PD-Price])))