create measure using text that ignores on page filters

[SteveIOW]

HI,

I have a table of data as shown

I am creating a report with 6 pages, each with  data from a different tab ( column D above).

I want to display the submitter's name though that is a Value in a different tab.

i.e. I need to create a measure from a non-numeric value that ignores the page filter set to the tab.

I assume I need to use ALLEXCEPT but how do I create a measure from a text value which will do this?

I got this far...

CALCULATE(LEFT(MainFacts[MetricValue],100), ALL(MainFacts), MainFacts[MetricName] = "SubmitterName")

Kind regards

Steve

[v-yalanwu-msft]

Hi, @SteveIOW ;

You could try it.

value =
CALCULATE (
    LEFT ( MainFacts[MetricValue], 100 ),
    FILTER ( ALL ( MainFacts ), [MetricName] = "SubmitterName" )
)

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

[SteveIOW]

sorry - accepted this by accident - 

I get this...