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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Jericho
New Member

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 @Jericho 

 

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 @Jericho 

 

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

@Jericho,

 

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.