Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Using constant Total from Linked table

Good morning,   I'm stuck in a seemingly easy problem, illustrated below:   I have two linked tables:     I'm trying to calculate the % of TV and Cinema in a bar chart with a slicer for ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi Anonymous,

     

    Please modify your measure as below:

    %Value =
COUNTA ( 'Tab2'[Value] )
    / CALCULATE ( SUM ( 'Tab1'[Count] ), ALLEXCEPT ( 'Tab1', Tab1[Country] ) )

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

Please modify your measure as below:

%Value =
COUNTA ( 'Tab2'[Value] )
    / CALCULATE ( SUM ( 'Tab1'[Count] ), ALLEXCEPT ( 'Tab1', Tab1[Country] ) )

Best regards,
Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thank you very much Yuliana!

 

Your solution did the trick (+ getting rid of a two-way relationship between my tabs!)

 

George.