Forum Discussion

carlochecchia's avatar
carlochecchia
Advocate I
5 years ago
Solved

Filter data from other tables

Hi all, I was wondering ig you could help me with the following issue: I currently have 3 datasets: a. Source   ID Weight 1001 1 1002 2 1003 3   b. abc   ID # Answe...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, carlochecchia 

     

    I am not sure how the below measure will influence your real case, but if your objective is to achieve the result that is shown in your picture, please try the below. 

     

    measurefix =
    CALCULATE (
    SUM ( Source[Weight] ),
    CROSSFILTER ( Source[ID], Questions[ID], BOTH ),
    CROSSFILTER ( Source[ID], Segment[ID], BOTH )
    )

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

    Linkedin: https://www.linkedin.com/in/jihwankim1975/

carlochecchia's avatar
carlochecchia
Advocate I
5 years ago

Thank you so much!

Could you also assist me on how to calculate the percentage of the column total?
Looking to achieve this result

Answer Female Male Total
blue 100% 33% 67%
Red -- 66% 33%
total 100% 100% 100%

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, 

Please try the below.

 

measure =
CALCULATE (
SUM ( Source[Weight] ),
CROSSFILTER ( Source[ID], Questions[ID], BOTH ),
CROSSFILTER ( Source[ID], Segment[ID], BOTH )
)
 
percentage =
DIVIDE( [measure], CALCULATE([measure], ALLSELECTED( Questions)))