cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nmckbcs Regular Visitor
Regular Visitor

Question about a SUMIF calculation in Power BI

Hello, 

I have a formula that I was able to create in both Power BI and Excel. However, In Power BI I lost the functionaility that I really needed. Essentially I have all these different methods for which a customer can contact us and the for each method there is a calculation associated with their satisfaction. Essentially in Power BI I would like to be able to replicate what I can do in Excel. Basically, I need to be able to show the question column name and the results for each (this is a net promoter score calculation with a weight associated with it). I would like to be able to show the below numbers and color only those where the count of customers is greater than 50 (as an example) and the green and red colors would be based on the scores provided. Links to the files are below. My big problem is the inability to color code or exclude fields if the response count isn't over a specific number and then color coding the columns individually based on the scores provided.

 

Screen Shot 2018-07-17 at 8.43.34 PM.pngScreen Shot 2018-07-17 at 8.44.06 PM.png

 

https://drive.google.com/open?id=1sCdZnJSTtpwWhgGeUXc08wmbkImDAK26 

 

https://drive.google.com/file/d/15iHZiuEb0MQt_OkAWYB9Yu-R9blg-1oX/view?usp=sharing 

6 REPLIES 6
rajendran Super Contributor
Super Contributor

Re: Question about a SUMIF calculation in Power BI

Hi @nmckbcs

 

Just provided solution in another thread, i hope you will get an idea if you refer this.

 

http://community.powerbi.com/t5/Desktop/Conditional-formatting-based-on-multiple-conditions/m-p/4648...

 

Thanks

Raj

 

nmckbcs Regular Visitor
Regular Visitor

Re: Question about a SUMIF calculation in Power BI

It makes a little sense but would need to know how to apply that to my issue. Any suggestions? 

nmckbcs Regular Visitor
Regular Visitor

Help with conditional formatting

Hello, 

I have a formula that I was able to create in both Power BI and Excel. However, In Power BI I lost the functionaility that I really needed. Essentially I have all these different methods for which a customer can contact us and the for each method there is a calculation associated with their satisfaction. Essentially in Power BI I would like to be able to replicate what I can do in Excel. Basically, I need to be able to show the question column name and the results for each (this is a net promoter score calculation with a weight associated with it). I would like to be able to show the below numbers and color only those where the count of customers is greater than 50 (as an example) and the green and red colors would be based on the scores provided. Links to the files are below. My big problem is the inability to color code or exclude fields if the response count isn't over a specific number and then color coding the columns individually based on the scores provided. Please note, the main thing is that I need to figure out how I can leverage the conditional formatting for the color requirement. Even if the process is manual that is OK also!

 

Screen Shot 2018-07-17 at 8.43.34 PM.pngScreen Shot 2018-07-17 at 8.44.06 PM.png

 

https://drive.google.com/open?id=1sCdZnJSTtpwWhgGeUXc08wmbkImDAK26 

 

https://drive.google.com/file/d/15iHZiuEb0MQt_OkAWYB9Yu-R9blg-1oX/view?usp=sharing

rajendran Super Contributor
Super Contributor

Re: Question about a SUMIF calculation in Power BI

Can you explain what issue you are facing in conditional formatting? As per your email, you are able to get the values and you can do formatting for each column based on the value.....

 

Thanks

Raj

nmckbcs Regular Visitor
Regular Visitor

Re: Question about a SUMIF calculation in Power BI

I have in excel but not Power BI
Highlighted
v-jiascu-msft Super Contributor
Super Contributor

Re: Question about a SUMIF calculation in Power BI

Hi @nmckbcs

 

I would suggest you transform your data structure then it would be easy. Please refer to the demo in the attachment.

Question_about_a_SUMIF_calculation_in_Power_BI

 

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 175 members 1,854 guests
Please welcome our newest community members: