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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.