Forum Discussion

Lenihan's avatar
Lenihan
Icon for Helper III rankHelper III
9 years ago

Calculate % based off total, rather than selected

I should warn you first off - I'm new - only been using Power BI for Desktop for 2 days, so still trying to understand everything. I have target date though coming up that I need to build several rep...
Need Help
Lenihan's avatar
Lenihan
Icon for Helper III rankHelper III
9 years ago

I'm getting there. 

For some reason, it is multiplying, and not dividing.

 

%Cancelled = COUNTX(FILTER('Dec 2016 Closed Changes',
                   'Dec 2016 Closed Changes'[Closure code]= "Cancelled"),
                   'Dec 2016 Closed Changes'[Closure code]) / [TotalCloseCode]

 

It is coming out with a value that is the product of the total Cancelled and the TotalCloseCode.   

 

edit: Even if I use just part of the formula

 

TotalCancelled = COUNTX(FILTER('Dec 2016 Closed Changes',
                     'Dec 2016 Closed Changes'[Closure code]= "Cancelled"),
                     'Dec 2016 Closed Changes'[Closure code])  

 

The value is coming out with the Total # of cancelled x the total number of rows.      I'm not sure what I'm doing wrong. I'm determining this by checking that row to add the card visual

Lenihan's avatar
Lenihan
Icon for Helper III rankHelper III
9 years ago

Ok, I figured it out - it was a new measure I needed. The new column would just populate the value all the way down all the rows, which is why it was as if multiplying. When I created the new measure for the %Cancelled, I was able to obtain the value needed.

 

Thank you for all the help vitinho