Measures Interaction with the table values displayed

[skis]

Hi,

I have created 4 measures using COUNTDISTINCT functions on specific columns in my data set and displayed them as separate cards. My measures would be,

1. Order Received

2. Orders Shipped

3. Orders not shipped

4. Orders on Backorders

I want to show the table values associated with the measures below the visual when I click the measure. But, when I do so, there is no interaction with the measure and the table. 

Any help would be appreciated.

Attaching the dropbox link of the sample data,

https://www.dropbox.com/scl/fi/s0i5tc2voc1p5vgxl7w1w/Orders-Shipped.xlsx?dl=0&rlkey=8pi5fodfhc47w9e9...

[Anonymous]

Hello @skis ,

Could you provide the formula for the following 4 measures? Do you want to display the different visual database data in the card value? Actually, the card cannot filter any other visuals. You can use the method in this blog as a workaround.

---

1. Order received

2. Orders sent

3. Orders in the shipped

4. Orders on pending orders

---

Best regards
Community Support Team _ Rena Rouan
If this post helps,then consider Accepting it as the solution to help the other members find it more.

[skis]

Hi,

Initialy I created 4 measures and it didn't filter out my other table visuals. Then, I created a column using CASE WHEN in MS-SQL(my data source)  and gave the criteria for my measures. So, now I have all my four measures as a column values in the tabel. In terms of visual, I created 4 differernt tables for each measure and just diplayed them as a single value in each table. And then, I kept a master table visual below that,  so that when ever I choose any one of the four table values (earlier it was measures), it filters out my master table visual.

[amitchandak]

@skis , Not very clear.

Do you need a visual like this

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000675?tab=Overview

Or a measure slicer

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...