Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

One Visual Three Columns Dependent On Slicer

Hi,   I have a table that has four fields. Customer (txt), Baseline (date), Target (date), Contract Value (decimal).   I want to create a matrix that will have the following fields: - Customer ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous

Try first create a new table using: 

New Table = SUMMARIZE(fact_RMR,fact_RMR[Target],fact_RMR[Baseline])

 

Then modify your formula filter with the selectedvalue in new table column, remember use the new table columns as the slicers.

 

Contract-Target = 
VAR MyTarget = selectedvalue(New Table[Target])
RETURN
calculate(sum(fact_RMR[Contract Value]),fact_RMR[Baseline]=MyTarget)

Contract-Baseline = 
VAR MyBaseline = selectedvalue(New Table [Baseline])
RETURN
calculate(sum(fact_RMR[Contract Value]),fact_RMR[Baseline]=MyBaseline)

 

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

     

    thank you, but it doesn't work. When my Target slicer and Baseline slicer have the same date - it works. But it will never be the scenario. When I select different dates in Target and Baseline, then the table is blank.

     

    Is there any other way?