Forum Discussion

flemingg62's avatar
flemingg62
Helper I
3 years ago
Solved

Replicating a Graph from Excel

Hi I need help reproducing a graph I have in Excel in Powe BI and have been trying to write a measure to use in graphs It calculates how many desk were utilised (at least once in the day) or  never...
Need Help
  • flemingg62's avatar
    flemingg62
    3 years ago

    Hi

    Thanks cracked it  hsed need to add a filter

    Locations Never Never used =
    VAR _Used =
        CALCULATE(DISTINCTCOUNT(BI_SurveyData[Location]), FILTER(BI_SurveyData,BI_SurveyData[Utilised]=1))
    VAR _ALL =
        CALCULATE ( DISTINCTCOUNT ( BI_SurveyData[Location]), ALL(BI_SurveyData[Location]) )
    RETURN
       _ALL - _Used
flemingg62's avatar
flemingg62
Helper I
3 years ago

Hi

Thanks, but I need a measure to count the numner of locations never used on each day