Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Advance Filtering and slicing options

I want to get the common outputs from Canada and France containing both

Eg. the First row should be - Bordeaux-style Red Blend | Black Hills | A. de Luze et Fils

Pls Refer To attached image

Jericho_0-1617011339171.png

 

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

Hi @Anonymous 

 

You can just create a filter on the visual to get the common outputs.

Try to apply the filter with Canada and France by show items when value is not empty

 

Sample data:

v-angzheng-msft_0-1617345844640.jpeg

Create a filter on the visual:

v-angzheng-msft_1-1617345844642.png

Result:

v-angzheng-msft_2-1617345844644.png

Is this the result you want? Hope this is useful to you

Please feel free to let me know if I misunderstand your question

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-angzheng-msft
Community Support
Community Support

Hi @Anonymous 

 

You can just create a filter on the visual to get the common outputs.

Try to apply the filter with Canada and France by show items when value is not empty

 

Sample data:

v-angzheng-msft_0-1617345844640.jpeg

Create a filter on the visual:

v-angzheng-msft_1-1617345844642.png

Result:

v-angzheng-msft_2-1617345844644.png

Is this the result you want? Hope this is useful to you

Please feel free to let me know if I misunderstand your question

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DataInsights
Super User
Super User

@Anonymous,

 

Try this measure:

 

Common Output = 
VAR vVariety =
    MAX ( 'winemag-data-1'[variety] )
VAR vResult =
    CALCULATE (
        DISTINCTCOUNT ( 'winemag-data-1'[country] ),
        'winemag-data-1'[variety] = vVariety
    )
RETURN
    vResult

 

Create a filter on the visual:

 

DataInsights_0-1617115764002.png

 

Sample data:

 

DataInsights_1-1617115784929.png

 

Result:

 

DataInsights_2-1617115800682.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




I believe this simpler version works too:

 

Common Output = CALCULATE ( DISTINCTCOUNT ( 'winemag-data-1'[country] ), ALL ( 'winemag-data-1'[country] ) )

 

For each variety (matrix row), clear the country filter context (matrix column), and calculate the number of distinct countries for the current variety.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!