Forum Discussion

sriramn84's avatar
sriramn84
Frequent Visitor
7 years ago
Solved

Groupby/Count - Chord Visual - How to retain relationships with other fields?

Hi All,

I am new here. I tried to use a Chord Visual and it works fine. But the visual typically takes 3 fields, From, To and a Value. 

Data:

From	To	DateTime	Type
A	B	10/06/2019 0:00	M1
A	C	10/06/2019 0:00	M1
B	D	10/06/2019 0:00	M1
A	B	10/06/2019 0:00	M2
B	D	11/06/2019 0:00	M2
A	C	11/06/2019 0:00	M3
A	C	11/06/2019 0:00	M1

I have created an Aggregated table(Modeling Tab>NewTable>Dax Query as below).

AggregatedTable =SUMMARIZE (TestChord;TestChord[From]; TestChord[To]; "CountExchange"; COUNT ( TestChord[From]))

Question: As you see below, there is no relationship between the AggregatedTable and TestChord table. Thus I cannot slice the Chord Visual based on the dates. How can I achieve this relationship? 

 

 Thanks for the help.

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, sriramn84 

    For your requirement, you don't need to create an Aggregated table.

    You need to just create a measure (Modeling Tab>NewMeasure>Dax Query as below)

    CountExchange measure = CALCULATE(COUNTA(TestChord[From]))

    Then drag this measure into visual as below:

     

    Now it will be filtered by DateTime. 

    here is pbix file, please try it.

     

    Best Regards,

    Lin

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    HI, sriramn84 

    For your requirement, you don't need to create an Aggregated table.

    You need to just create a measure (Modeling Tab>NewMeasure>Dax Query as below)

    CountExchange measure = CALCULATE(COUNTA(TestChord[From]))

    Then drag this measure into visual as below:

     

    Now it will be filtered by DateTime. 

    here is pbix file, please try it.

     

    Best Regards,

    Lin