Slicer selecting dimension to switch measure in the visual

[Anonymous]

Hi All,

I try to use the slicer to switch the measure display in visual :

03 COvsNS MTD = if('BPC Finance Cube Flat'[Account]="Net Sales",'Measure'[03 vsLY MTD],'Measure'[02 Actual MTD]/'Measure'[02 Actual MTD All])

Example :

If i select "Net Sales" in the Slicer i want it to display measure vsLY but other selection will br vsNS MTD.

Please advice

Thanks

[Anonymous]

Thank You

[wdx223_Daniel · Accepted solution]

03 COvsNS MTD = if(max('BPC Finance Cube Flat'[Account])="Net Sales",'Measure'[03 vsLY MTD],'Measure'[02 Actual MTD]/'Measure'[02 Actual MTD All])