I am having list of ID and set of measures. I wanted to create a new calculated field for ID in such a way that If there is no selection on any measure then set a default ID, otherwise show the IDs based on the selection. The reason why I am trying this because the the list of IDs are huge , hence it takes lot of time to load, but If i create this calculated field then the IDs will load only if any selection where made.
Currently I tried with this logic , which doesn't work
IF [<Measure1>] = 'All' or [<Measure2>] = 'All' then IDs ='XXXXXXXX' else IDS = ID END.