Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculate Not working

Hi All,  I have 2 tables: Projects and Risks where a 1:many relationship exists from Projects:Risks. The Risk table has a status column which is of type Choice ( 3 values): Active, Closed, Postponed...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,Anonymous .Hello,Greg_Deckler,thanks for your concern about this issue.
    And I would like to share some additional solutions below
    I am glad to help you
    There seems to be an error in your dax code, you can try this measure:

    M_result = 
VAR _onlyactive =
CALCULATE(COUNT ( Risk[Project ID]), FILTER( 'Risk',Risk[pmotest_riskstatus] = "646440000" && Risk[pmotest_riskstatus_display] = "Active"))
RETURN    
    _onlyactive

     

    In the calculate () function, the expression to be evaluated should not use variables as much as possible.


    here is my test result



    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

    Best Regards,

    Carson Jian,

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,Anonymous .Hello,Greg_Deckler,thanks for your concern about this issue.
And I would like to share some additional solutions below
I am glad to help you
There seems to be an error in your dax code, you can try this measure:

M_result = 
VAR _onlyactive =
CALCULATE(COUNT ( Risk[Project ID]), FILTER( 'Risk',Risk[pmotest_riskstatus] = "646440000" && Risk[pmotest_riskstatus_display] = "Active"))
RETURN    
    _onlyactive

 

In the calculate () function, the expression to be evaluated should not use variables as much as possible.


here is my test result



I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello Carson,

I updated the DAX with your suggestion and I got it to work as expected. I tried the variation without the Filter function like this & it also worked:

VAR _getActiveRisks1 = CALCULATE( COUNT(Risk[Project ID]), Risk[pmotest_riskstatus] = "646440000", Risk[pmotest_riskstatus_display] = "Active")
 
thanks a lot for testing on your end. 
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,Anonymous 
    I'm glad you solved your problem, if you have any other questions about power BI, you are welcome to share them on the forum as it will help more users with similar problems!

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

    Best Regards,

    Carson Jian,

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.