Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm trying to accomplish something that seems tricky. I have calculated values: Average (age), Average (balance), Net worth.
I have those values for 5 different states (NY, KY, CA, FL, TX) , and a filter for states.
Once I've filter for a state, I'd like to show a table with Age, balance and net worth as rows, a column for the states value, and a column combining all the states.
Is that feasable?
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Ahish, thank you very much, was not aware of the IsInSCOpe function.
I might have a complementeray question that surfaced from using this:
If one of my measures was a calculate, that had a filter at the end, how do I combien the ALL and the FILTER in the same calculate?
You are welcome. It really depends upon the case. Start a new thread with your question - explain the question, share some data and show the expected result.
Name | State | Age | Balance | Net worth |
Steve | NY | 40 | 100 | 5000 |
Rick | NY | 50 | 300 | 15000 |
Samantha | KY | 50 | 400 | 10000 |
Qourtney | KY | 60 | 600 | 20000 |
Kyle | CA | 20 | 50 | 100 |
Paul | CA | 30 | 150 | 300 |
Shequanisha | FL | 40 | 500 | 20000 |
Danika | FL | 50 | 1500 | 40000 |
Bossman | TX | 50 | 1200 | 6000 |
Greg | TX | 40 | 600 | 1000 |
And the result:
Florida | National average | |
Age | 45 | 43 |
Balance | 1000 | 540 |
Net worth | 30000 | 11740 |
Hi,
You may download my PBI file from here.
Hope this helps.
Hey @Sibrulotte ,
I'm not sure if I understand what for you are looking for.
I'm using a matrix visual, the next screenshot shows the initial visualization:
The Values bucket in the formatting pane of the matrix visual provides an option called Show on rows
Turning this option to on changes the layout of the matrix visual to this:
All the fields from the Values well are transposed, from columns to rows.
Hopefully, this is what you are looking for.
If not, consider creating a screenshot that shows how the visual looks like, and use Excel to create the layout you want, and paste this layout as a 2nd screenshot.
Regards,
Tom
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |