Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Measures and Filters

Currently, I have my data set to 3 shifts; A, B and C. I need to get a card to show the total number of days where there was more than 20 occurrences of High in an hour. I'm at a complete loss on how...
Need Help
Show and Tell
Tutorial Requests
  • rsbin's avatar
    rsbin
    2 years ago

    Anonymous ,

    Copied your data into my pbix as Sheet1. 
    Then re-did all columns and the Measure.  Think I may have had to edit one of my calculated columns.

    Result now comes out as 2.
    Please review and hopefully this works for you.

    Regards,

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
2 years ago

Anonymous ,

Please review the attached pbix file.

Solution involves creating several calculated columns and then finally a measure to Count Days > 20.

Hope you can follow through on the logic I used.  May need some tweaks depending on the remainder of your data set.

Good Luck and Regards,