Forum Discussion
sparker95
3 years agoFrequent Visitor
Filtering using slicer
I have a table with columns for 'Status' which has 5 options {1. Fee Forecast, 2. Confirmed, 3. Likely, 4. Planning, 5. Spec}, another that is 'Date' that gives me {Q1, Q2, Q3, Q4} and finally a 'Fe...
- 3 years ago
Hello sparker95,
Can you please try:
1. Create Individual Slicer Measures
Fee Forecast % = [1. Fee Forecast %. Value] Confirmed % = [2. Confirmed %. Value] Likely % = [3. Likely %. Value] Planning % = [4. Planning %. Value] Spec % = [5. Spec %. Value]2. Create Individual Adjustment Measures
Fee Forecast Adjusted = SUM(Table2[Fee]) * (1 + [Fee Forecast %] / 100) Confirmed Adjusted = SUMX( FILTER(Table2, Table2[Status] = "Confirmed"), Table2[Fee] * (1 + [Confirmed %] / 100) ) Likely Adjusted = SUMX( FILTER(Table2, Table2[Status] = "Likely"), Table2[Fee] * (1 + [Likely %] / 100) ) Planning Adjusted = SUMX( FILTER(Table2, Table2[Status] = "Planning"), Table2[Fee] * (1 + [Planning %] / 100) ) Spec Adjusted = SUMX( FILTER(Table2, Table2[Status] = "Spec"), Table2[Fee] * (1 + [Spec %] / 100) )3. Create a Master Measure to Combine Adjusted Values
Adjusted Fee Total = [Fee Forecast Adjusted] + [Confirmed Adjusted] + [Likely Adjusted] + [Planning Adjusted] + [Spec Adjusted]Should you require further assistance, please do not hesitate to reach out to me.
Sahir_Maharaj
3 years agoSuper User
Hello sparker95,
Can you please try:
1. Create Individual Slicer Measures
Fee Forecast % = [1. Fee Forecast %. Value]
Confirmed % = [2. Confirmed %. Value]
Likely % = [3. Likely %. Value]
Planning % = [4. Planning %. Value]
Spec % = [5. Spec %. Value]2. Create Individual Adjustment Measures
Fee Forecast Adjusted =
SUM(Table2[Fee]) *
(1 + [Fee Forecast %] / 100)
Confirmed Adjusted =
SUMX(
FILTER(Table2, Table2[Status] = "Confirmed"),
Table2[Fee] * (1 + [Confirmed %] / 100)
)
Likely Adjusted =
SUMX(
FILTER(Table2, Table2[Status] = "Likely"),
Table2[Fee] * (1 + [Likely %] / 100)
)
Planning Adjusted =
SUMX(
FILTER(Table2, Table2[Status] = "Planning"),
Table2[Fee] * (1 + [Planning %] / 100)
)
Spec Adjusted =
SUMX(
FILTER(Table2, Table2[Status] = "Spec"),
Table2[Fee] * (1 + [Spec %] / 100)
)3. Create a Master Measure to Combine Adjusted Values
Adjusted Fee Total =
[Fee Forecast Adjusted] + [Confirmed Adjusted] + [Likely Adjusted] +
[Planning Adjusted] + [Spec Adjusted]Should you require further assistance, please do not hesitate to reach out to me.