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
PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

Can you share some dummy data or a link to a dummy PBIX file?

flemingg62's avatar
flemingg62
Helper I
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