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

[sriramn84]

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.

[v-lili6-msft · Accepted solution]

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

[sriramn84]

That was simple and worked perfect! Thank you so much Lin! @v-lili6-msft