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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 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.

Top Solution Authors