topic Measure interaction with table visual in DAX Commands and Tips

Measure interaction with table visual

Anonymous — Fri, 08 May 2020 14:42:08 GMT

@ Greg_Deckler, Amit

Hi,

I have a matrix visual where is use 2 measures as rows (by using "Show on rows" option). The issue I'm facing is the measures on selection of any particular cell in the matrix is not passed to the related Table visual and hence the data in Table visual is not getting filtered accordingly. Is there a solution for me to pass measure value in the selected cell to another related visual?

	date 1	date 2	date 3
Credit	-100	-200	-300
Debit	100	200	300

Ex:

On clicking -100 , in above table the sum of entire column (-100 and 100) is getting passed to the related visual. That is "Credit" is not being passed. Is there a way this can be resolved?

Re: Measure interaction with table visual

Greg_Deckler — Fri, 08 May 2020 15:15:35 GMT

I tried replicating this and cannot. When I click on -100 cell in the matrix I get -100 passed to my other visual. Or I am not understanding something.

See attached PBIX.

Re: Measure interaction with table visual

Anonymous — Sun, 10 May 2020 17:55:02 GMT

Greg_DecklerThank you looking into the issue Greg.

I'm not able to attach the pbix file here. Hence attaching the screenshot of a sample dashboard.

If i click on -40 from my matrix, the entire column corresponding to it is being selected . And it is being passed to the table visula. I want only the -40 to be passed. How do i achieve this?

The formula used for creating the measures CREDIT and DEBIT are as follows:

Credit = SUMX (

SUMMARIZE (

'Table',

'Table'[Account Number],

'Table'[Type],

"TotalCount", if([Sum-Amount]<0,[Sum-Amount],blank())

[TotalCount]

)

Debit = SUMX (

SUMMARIZE (

'Table',

'Table'[Account Number],

'Table'[Type],

"TotalCount", if([Sum-Amount]>0,[Sum-Amount],blank())

[TotalCount]

)

Re: Measure interaction with table visual

Anonymous — Mon, 18 May 2020 05:00:16 GMT

Greg_Deckler@amitchandak Any idea on this?