Forum Discussion

Anonymous

Not applicable

6 years ago

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 ...

Community Champion

6 years ago

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.

showonrows.pbix33 KB

Anonymous
Not applicable
6 years ago
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]
)
- Anonymous
  Not applicable
  6 years ago
  Greg_Deckler@amitchandak Any idea on this?