Percentage of a column is above another column

sesa145093 — Tue, 18 May 2021 14:51:04 GMT

I am looking to get a percentage:

Looking to take the Estimated cost and Contract Price and calculate a percentage of how many are over the estimated cost.

I have created a Delta column that gives me the percentages of change (e.g. if its .001 above this triggers a conditional formating to Red and if its a negative number it goes to Green)

What I'm needing is the number of contracts that are above the estimated cost column.

Any help would be greatly appreciated!

Re: Percentage of a column is above another column

Anonymous — Tue, 18 May 2021 21:52:27 GMT

You want the total number of contracts that are above the estimated cost column as one number only? For that, you can add a card visual, put the "contracts" field in this card and select aggregate by count. Finally, use a visual filter to filter this card on [Delta Cost]>0.001

topic Percentage of a column is above another column in DAX Commands and Tips

Percentage of a column is above another column

Re: Percentage of a column is above another column