Forum Discussion

tcouey's avatar
tcouey
Frequent Visitor
4 years ago
Solved

Help with Divide Function with Countx and Filter

Hi, and thanks for any help. Over the last couple months I've had the opportunity to start editing dashboards at work and am really enjoying it and want to keep pursuing the skill.   I'm trying to ...
Need Help
  • Shishir22's avatar
    Shishir22
    4 years ago

    Hello tcouey ,

     

    Please use below measure to fix your error-

     

    MRC Controls as % of Total Issues = DIVIDE(Countx(Filter(Controls,controls[mrc_control] = "Y"),controls[id]), count(test_issues[id]),BLANK())

     

    If that dont gives you expected results please share sample data and expected output in tabular format.

     

Shishir22's avatar
Shishir22
Solution Sage
4 years ago

Hello tcouey ,

 

Please use below measure to fix your error-

 

MRC Controls as % of Total Issues = DIVIDE(Countx(Filter(Controls,controls[mrc_control] = "Y"),controls[id]), count(test_issues[id]),BLANK())

 

If that dont gives you expected results please share sample data and expected output in tabular format.