Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
PBIX link is here: https://www.dropbox.com/s/41rckk17i870t2v/Slicer%20to%20Create%20Calculated%20Table.pbix?dl=0
I have 3 parameters:
I'd like to create a calculated table where the SELECTEDVALUE of the lease term dictates the number of rows and the Acquisition Cost and Revenue as % of Acquisition Cost are repeated as separate columns. Example desired output is shown here:
Lease Term | Acquisition Cost | Revenue % |
1 | 300 | 0.02 |
2 | 300 | 0.02 |
3 | 300 | 0.02 |
4 | 300 | 0.02 |
5 | 300 | 0.02 |
6 | 300 | 0.02 |
7 | 300 | 0.02 |
8 | 300 | 0.02 |
9 | 300 | 0.02 |
10 | 300 | 0.02 |
11 | 300 | 0.02 |
12 | 300 | 0.02 |
Here's an image of the visuals showing the Parameter Slicers. The lower left-hand corner is the calculated table, where I have SELECTEDVALUES({parameter},999) and it's defaulting as if nothing is selected. The table at lower center shows the Measures of the slicer parameters.
Thanks in advance!
Hey,
this will not work, as calculated tables are only recalculated on data refresh.
Calculated tables only "react" on user interactions, e.g. selecting values from a slicer inside a measure.
Regards,
Tom
I'm a bit confused about your comment: "Calculated tables only "react" on user interactions, e.g. selecting values from a slicer inside a measure."
If my user changes the slicer, which changes the related measure, then I want to populate a column with the value in that measure.
To simplify, let's assume I had a table with one index column: 1, 2, 3, 4, 5, 6. When I change the slicer from "A" to "B", I want the column "Slicer" to change from A to B for each 1, 2, 3, 4, 5, 6.
e.g.: Existing
Index | Slicer |
1 | A |
2 | A |
3 | A |
4 | A |
5 | A |
6 | A |
user changes slicer from "A" to "B"
new calculated table:
Index | Slicer |
1 | B |
2 | B |
3 | B |
4 | B |
5 | B |
6 | B |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
98 | |
79 | |
74 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |