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
shivendr
Helper I
Helper I

Looking for sum of values which are not filtered in the slicer.

Hi, 
I have data in one Table, which is having  3 columns which i need to use.
1. Name of Country's 
2. customer countries
3. Amount in dollars.

Country has more than one customer country including parent country.
Screenshot 2023-09-14 171238.jpg

I have slicer based on the Name country, I need to find out the amount which is contributed by customer country, when slicer is not selecting the particular country.

For example : If name country is columbia than its customer countries is Argentina, Columbia , maxico and so on, If I select all the countries in the slicer excluding Columbia, I want to know how much columbia's amont when not selected in the slicer.

I Created a measure to get all the countries which is not selected in the slicer by the following DAX: 

Measure =
VAR A =
CONCATENATEX (
FILTER (
ALL (Name of Country),
NOT' Name of Country'
IN VALUES ( Name of Country )
),
'Name of Country, ","
 
)
Return (A)

This is giveng me names of the countries which are not selected in the slicer but in single row, I need a solution of this problem.
Help me,
Thanks in advance
1 ACCEPTED SOLUTION

Hi,

Refer to the attached file.

Hope this helps.

Ashish_Mathur_0-1694828679240.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

7 REPLIES 7
Ashish_Mathur
Super User
Super User

Hi,

Share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

I can't share the file

Hi,

Please find attached the PBI file.

Ashish_Mathur_0-1694752489255.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi Ashish, Appreciate your effort and support, But this is not desired solution.
Screenshot 2023-09-15 104318.jpgPlease refer the screenshot

Hi,

Refer to the attached file.

Hope this helps.

Ashish_Mathur_0-1694828679240.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Thank you Ashish, Great Work!

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

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.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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