topic Re: Help with DAX - Percent Query in DAX Commands and Tips

Help with DAX - Percent Query

Anonymous — Mon, 28 Mar 2022 14:39:26 GMT

Hi All,

Does anyone know a DAX where I can work out the percentage of jobs complete please?

=(Total Jobs - Open Jobs ) / Total Jobs *100 - Is what i use in excel. I cant seem to figure this out in Power BI as a saved measure.

I have measures for - All Jobs, Open Jobs and Completed Jobs.

Thanks

amitchandak — Mon, 28 Mar 2022 15:38:59 GMT

Anonymous , Assume you have two measures [Open Jobs], [Total Jobs]

Divide([Open Jobs], [Total Jobs])

Mark this a % column

Whitewater100 — Mon, 28 Mar 2022 16:49:37 GMT

Hi Bidds10:

There is usually more than one way to do this. A lot of measure are built upon other measures, branching out.

I'm using my own made up data but should apply to yours if you change the table name and column names.

You'll see, but the measure for the % complete is:

Perc Complete = DIVIDE([Completed Jobs],[Total Jobs],0)

Incomplete Jobs = CALCULATE([Total Jobs], JobStatus[Status]="INC")

Completed Jobs = [Total Jobs] - [Incomplete Jobs]

Anonymous — Tue, 29 Mar 2022 08:36:53 GMT

Thanks both. Neither of these seems to be giving me the correct information.