Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm using multiple slicers. The goal is to select a subtable of one slicer out of the original whole data(not affected by other slicers if the user use any of them)
ALLSELECTED('table'[targetColumn]) doesn't work since this would still be affected by the other slicers
Solved! Go to Solution.
@kmes40505 your measure should be
TotalCount = CALCULATE(SUM(Sheet1[count]),ALLEXCEPT(Sheet1, Sheet1[targetSlicer]))
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@kmes40505 i just tested, a table with 3 column and following measure give me count of all rows regardless if user slicer the data from another columns
Measure = VAR x = CALCULATETABLE( ALLSELECTED( Table1[Column1] ) ) RETURN COUNTROWS( x )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
the actual code i use is this:
(all of the following are measure)
totalCount = CALCULATE(SUM('table'[count]),ALLSELECTED('table'[targetSlicer]))
TotalPercentage = SUM('table'[count]) / [totalCount]
@kmes40505 are you open to share sample data? Your measures have all different columns,
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I've modified the column names. was my bad
btw i use table(under visualizations) for other slicers since slicer cannot show multiple values. but for the targetSlicer it is using slicer
Hi @kmes40505
Could you give me an example for better analysis?
it is prefered to provide an example data and expected result and actual result.
Best Regards
Maggie
I can't attach an example file here... following is the step to recreate the issue:
1. create a data (excel etc) with
targetSlicer otherSlicer count
choice1 other1 1
choice2 other1 10
choice1 other2 100
2. import data into power bi
3. create "slicer" for targetSlicer
4. create "table" for otherSlicer
5. create measure:
@kmes40505 your measure should be
TotalCount = CALCULATE(SUM(Sheet1[count]),ALLEXCEPT(Sheet1, Sheet1[targetSlicer]))
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |