Forum Discussion

pmadam's avatar
pmadam
Icon for Helper II rankHelper II
5 years ago

DAX HELP!!

Hi Team,

 

Please help with below request.

 

I  have 3 measures and 3 dimensions as shown below.

 

Dims                                 Measure

Branch Budget                 Budget

InsideSalesName              InsideSalesBudget

    ->Inside SalesNumber

OusideSalesName         OutsideSalesBudget

   ->OutsideSalesNumber

 

So i need to create single  calculated measure 'Budget' that displays respective measure value depending on dimension picked by user in visual.

 

We we having this in multi-dimensional like below but i need in DAX

 

SCOPE([MEASURES].[Budget]);
SCOPE([Outside Sales].[Outside Sales].[Outside Sales Name].MEMBERS);
IF NOT ISEMPTY([MEASURES].[Ship Resale - SALE]) OR NOT ISEMPTY([MEASURES].[Book Resale - SALE]) THEN THIS = [MEASURES].[Outside Sales Budget]
END IF;
IF ISEMPTY([MEASURES].[Ship Resale - SALE]) AND ISEMPTY([MEASURES].[Book Resale - SALE]) THEN THIS = NULL
END IF;
END SCOPE;
SCOPE([Outside Sales].[Outside Sales].[Outside Sales Number].MEMBERS);
IF NOT ISEMPTY([MEASURES].[Ship Resale - SALE]) OR NOT ISEMPTY([MEASURES].[Book Resale - SALE]) THEN THIS = [MEASURES].[Outside Sales Budget]
END IF;
IF ISEMPTY([MEASURES].[Ship Resale - SALE]) AND ISEMPTY([MEASURES].[Book Resale - SALE]) THEN THIS = NULL
END IF;
END SCOPE;
END SCOPE;

 

 

1 Reply