Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculate Expected Entries

Hi, I have a a dataset which constains a number of floors which are used to carry out heath and safety checks, these are categorised into buildings. I want to flag when an entry has not been complete...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

As I said above - create dimension tables that list all buildings with all floors, regardless if they had a health check or not.

 

You could theoretically glean that from the fact data (via VALUES() )  but that is risky since you may miss floors that _never_ had inspections.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I would like a measure to instead display text instead of values for those that are higher or lower than my expected value that's what I am trying to achieve. 

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Would you please show us some sample data and your expected output for a better understanding?  Maybe you need unpivot steps in your raw data.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I managed to figure it out myself by grouping my data via power query then providing a measure to stipulate if the column was less than 1 to class it as missing data. Thank you for all your suggestions though.