Forum Discussion
Measure interaction with table visual
@ 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?
3 Replies
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.
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])Greg_Deckler@amitchandak Any idea on this?
