Forum Discussion

htaunay's avatar
htaunay
Microsoft Employee
10 years ago
Solved

Calculating the reason between aggregated rows in different tables

Hi everyone,   I'm trying to generate numbers that represent the reason between two columns from different tables, but in different timeslices from which the original data was generated. Here is an...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    hi htaunay

     

    1: Create a calculated column in both tables:

     

    Date = (DATE(YEAR('Tabla A'[Time]);MONTH('Tabla A'[Time]);DAY('Tabla A'[Time])))

     

    2. Create a measure:

     

    Share = CALCULATE(sum('Tabla B'[Count])/CALCULATE(SUM('Tabla A'[Count])))

     

    3. Put a Table Visual and a Slicer by Date

     

    In table Visual:

    Segment

    Share

     

     

     

     

     

Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

hi htaunay

 

1: Create a calculated column in both tables:

 

Date = (DATE(YEAR('Tabla A'[Time]);MONTH('Tabla A'[Time]);DAY('Tabla A'[Time])))

 

2. Create a measure:

 

Share = CALCULATE(sum('Tabla B'[Count])/CALCULATE(SUM('Tabla A'[Count])))

 

3. Put a Table Visual and a Slicer by Date

 

In table Visual:

Segment

Share

 

 

 

 

 

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    10 years ago

    htaunay

     

    In addtion to Vvelarde, do not forget to map a proper relationship between table A and table B.

     

    If you have any question, feel free to let me know.