Conditional Measure is working partially

[Anonymous]

Hi, I am facing a strange issue with my dax measure below:

Count of Cost Centers = 
SUMX (
    CROSSJOIN ( VALUES('New Prod+Rev Merge1'[Production Team]),VALUES('New Prod+Rev Merge1'[CostCenter])),
     IF([CF/BOE]<SUMX('Threshold Table','Threshold Table'[Value]),1,0)   
)

the above measure is used to calculate the count of cost centers whose "CF/BOE" value is less than the selected threshold.

The threshold contains the following values : 30,20,10,0,-10,-20,-30.

Also, the "CF/BOE" is also a measure created using simple Divide function.

Problem: When the selected threshold value is less than or equals to 0 (0,-10,-20,-30) then the outcome is coming correct but when the selected threshold value is more than 0 (10,20 or 30) the numbers are very weird like in millions which cant be true as total number of cost centers in the data is around 1500.

[Fowmy]

@Anonymous 

I am not sure what you are adding the threshold if it selected
Try like:

Count of Cost Centers = 
SUMX (
    CROSSJOIN ( VALUES('New Prod+Rev Merge1'[Production Team]),VALUES('New Prod+Rev Merge1'[CostCenter])),
     IF(
         [CF/BOE] < SELECTEDVALUE('Threshold Table'[Value]),1,0)   
)

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

[Anonymous]

@Fowmy Hi, Yes if i replace the formula with selected value, then also the issue is same.

[Fowmy]

@Anonymous 

Then I have not fully understood your problem, if you can share your PBIX file with sample data then I can have a look at it.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn