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
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Try modifying your DAX expressions as follows:

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

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

 

Thanks,

Pragati