Forum Discussion

Rosenshredder's avatar
Rosenshredder
Icon for Helper I rankHelper I
3 years ago

Adding four measures with non-blank values returns blank value, but not always?

I'm not sure how to even phrase this, but I have four measures that are working just fine. Then I have a fifth measure that adds the four measured values together.    The fifth measure works for on...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Rosenshredder Where is the 5th measure being used? In a Card visual or something else?

Rosenshredder's avatar
Rosenshredder
Icon for Helper I rankHelper I
3 years ago

Yes, all 5 measures are being used in card visuals, and there are no differences in the filters applied to them.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Rosenshredder Any chance you can post the PBIX or sample data with instructions on how to recreate the issue?

    • Rosenshredder's avatar
      Rosenshredder
      Icon for Helper I rankHelper I
      3 years ago

      I'm not exactly sure how to do that. Let me try using screenshots.

       

      Here is the measure working normally with Vipers crew selected:

      Here is it with a different crew selected:

       

      And here is the measure driving the KPA Score card:

       

      KPA Score = (('kpaehs DoghouseInspection'[DH Score])+('kpaehs ForkliftInspection'[FL Score])+('kpaehs PronghornJSA'[JSA Score])+('kpaehs SandCradleInspection'[Sand Cradle Score]))/4
       
      As you can see, each of the four measures produce a value for both selected crews, but then adding them up only works with one particular crew selected. I'm at a total loss - it seems so simple.