Forum Discussion
In Context operator equivalent in Power BI
Hi, I have created a formula in Business Objects which i want to replicate in DAX power bi but not sure how to do this. Can anyone offer some help/advice on how i can do this. The formula in ...
Hi lbendlin
I am not sure how to attach a sample file.
I want to replicate the above measure used in Business Objects into power bi. I have tried to split the above into 2 separate measures:
first measure = CALCULATE(DISTINCTCOUNTNOBLANK('First Contact'[Advice & Support KI_STEP_ID]),'First Contact'[Advice & Support STEP_STATUS]="COMPLETED")
second measure = CALCULATE(DISTINCTCOUNTNOBLANK('First Contact'[Followup KI_STEP_ID]),'First Contact'[Followup STEP_STATUS]="COMPLETED")
I now need to add the 2 measures so measure created as: total measure = first measure + second measure
Up to this point i works. However i now need to create 3 measures:
Total Measure is 1 = CALCULATE(DISTINCTCOUNTNOBLANK('First Contact'[First Contact WORKFLOW_ID]),FILTER('First Contact',[Measure 3]=1))
Total measure is 2 = CALCULATE(DISTINCTCOUNTNOBLANK('First Contact'[First Contact WORKFLOW_ID]),FILTER('First Contact',[Measure 3]=2))
Total measure is 3 or more = CALCULATE(DISTINCTCOUNTNOBLANK('First Contact'[First Contact WORKFLOW_ID]),FILTER('First Contact',[Measure 3]>=3))
This gives me the below result:
| Month | Nov |
| Total Measure is 1 | 75 |
| Total Measure is 2 | 9 |
| Total Measure is 3 or more |
I am expecting this result:
| Nov | |
| Total Measure is 1 | 73 |
| Total Measure is 2 | 4 |
| Total Measure is 3 or more | 5 |
For some reason, the maximum count is 2 which is wrong.
