Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Nested measures: issue when same column filtered

Morning everyone,   I have experienced this issue previously and have finally decided to ask about it, just in case there is a solution for it. When I create metrics from previous metrics, and try...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Please Add Filter() function to the formula.

    Total surveys_Q6_excellent = CALCULATE([Total surveys_Q6], FILTER(test, Test[Q6] = 10))

    Tips: Using either the operator == or the ISBLANK function to distinguish 0 and blank.

     

    Best Regards,

    Jay

speedramps's avatar
speedramps
Super User
4 years ago
Please consider this solution
Total surveys_Q6_excellent = CALCULATE([Total surveys], Test[Q6] = 10)
 

Remember we are BI community voluntrees so please click the thumbs-up for me taking the trouble to help you and then accept the solution if it works.  Thank you !