Forum Discussion
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...
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
Community Champion
Community ChampionAnonymous ,
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,
Perfect that seems to be doing the trick, the numbers don't match up with what I calculated via Excel, so I'll check that out. But the calculations appear to be working.
Thank you!