Forum Discussion
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...
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
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