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
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.
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:
Solved! Go to Solution.
Hi,
Refer to the attached file.
Hope this helps.
Hi,
Share the download link of the PBI file.
I can't share the file
Hi Ashish, Appreciate your effort and support, But this is not desired solution.
Please refer the screenshot
Thank you Ashish, Great Work!
You are welcome.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
90 | |
82 | |
76 | |
64 |
User | Count |
---|---|
144 | |
109 | |
108 | |
100 | |
96 |