Using Switch to Evaluate Column Values to Multiply Measures

[Anonymous]

I am working on a report that requires me to multiply a measure by 4 different peramiters based on a table column valup.  The equation that I would like to use is as follows: 

Measure = SWITCH(

                             TRUE(), 

                                   Cost[Cost Allocation] = "Building", Measure1[AVG Cost at New City] * 'Concept SF'[Peramerer Value],

                                   Cost[Cost Allocation] = "Site", Measure1[AVG Cost at New City] * 'Concept Acre'[Peramerer Value],  

                                   Cost[Cost Allocation] = "GC", Measure1[AVG Cost at New City] * 'Concept Duration'[Peramerer Value],

                                   Measure1[AVG Cost at New City] * 'Concept PGC Duration'[Peramerer Value])

The issue that I have is when I type this in as a measure I cant refferance the tabel Cost[Cost Allocation], there is an an image of the table below.  The end result is to have the above mentioned measure displayed in a table on a report.  Any sugestions on how to solve this issue?

 

[amitchandak · Accepted solution]

@Anonymous , you should not use measure in a calculated column. the measure will not respond to the slicer value. User measures

Measure = SWITCH(
TRUE(),
max(Cost[Cost Allocation]) = "Building", Measure1[AVG Cost at New City] * 'Concept SF'[Peramerer Value],
max(Cost[Cost Allocation])= "Site", Measure1[AVG Cost at New City] * 'Concept Acre'[Peramerer Value],
max(Cost[Cost Allocation])= "GC", Measure1[AVG Cost at New City] * 'Concept Duration'[Peramerer Value],
Measure1[AVG Cost at New City] * 'Concept PGC Duration'[Peramerer Value])