Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a measure that is taking the sum of a column * another measure.
SUM(Column1) * Measure1
However when I select a subset, for example a month row in the data table, the total measure value doesn't change to match the value for just that month in another table visual. It keeps the overall value, is there any way to get the measure value to change based on table row selection?
Example tables :
Table one
Month | Value Of Measure : SUM(Column1) * Measure1 | Measure 2 : SUM(Column1) * Measure1 / Quantity |
1/1/2022 | 10 | 2 |
2/1/2022 | 10 | 2 |
3/1/2022 | 10 | 2 |
Total | 30 | 2 |
Table two
Segment | Value Of Measure : SUM(Column1) * Measure1 | Measure 2 : SUM(Column1) * Measure1 / Quantity |
1 | 5 | 2 |
2 | 15 | 2 |
3 | 10 | 2 |
Total | 30 | 2 |
Is there a way if I select a row in table 1 that table 2 shows the value of the measure as the total? For example if I select row 1 in table 1 the total show for column 2 in table 2 should now be 10 instead of 30.
Hi, @Materous
I have not been able to fully understand, please advise the relationship between Tables 1 and 2. Can you provide more sample data for testing?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.