DAX calculation for Tiering

DAX DAX Calculations
1

Good day,

Hope you can help, i previously asked for assistance with DAX measure which worked. (DAX Assistance - (VAR + IF Statement))

image
image772×203 6.44 KB

I now need to modify this measure based on screen shot about where each return value will now contain a extra layer of calculation.

Example:

Customer1 : >1000000, <28299870 = 3%, >28299870 =4%

thanks
Neilon

2

Hi All,

Not sure if anybody has some ideas for this, previous dax was as follows:

CA Distributor Growth Target =

VAR Silver = {“1000065531”,“1000065478”,“1000064993”}

VAR Gold = {“1000064774”,“1000065090”,“1000141700”,“1000144987”,“1000065320”,“1000065428”, “100065187”}

VAR CustomerCODE = SELECTEDVALUE(CustomerBuyer[Customer Buyer Code])

Return

IF(CustomerCODE IN Silver && [ACT 36] > 5000000,

IF(CustomerCODE IN Gold && [ACT 36] > 10000000,3,0))

now i need to add the 2nd level tier for some customers

3

Hi,

Thanks for posting your query .pls provide your working pbix and can you explain your req more clearly.

Thanks,
Anurag

4

Hi @neilonbooysen, I noticed you didn’t provide a PBIX file. Providing one will help users and experts find a solution to your inquiry faster and better.

Check out this thread on Tools and Techniques for Providing PBIX Files with Your Forum Questions

Here are some videos that may help you masking sensitive data and create datasets and data models representative of your problem:

Not completing your data may sometimes cause delay in getting an answer.

5

Hi @neilonbooysen, we’ve noticed that no response has been received from you since October 21.

We waited for the masked demo pbix file and any other supporting links and details. Due to inactivity, we’ll be tagging this post as Solved.