{"id":3993,"date":"2022-02-08T14:58:08","date_gmt":"2022-02-08T22:58:08","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3993"},"modified":"2022-02-08T14:58:09","modified_gmt":"2022-02-08T22:58:09","slug":"how-to-fix-total-row-is-displaying-0-instead-of-real-sum","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3993","title":{"rendered":"How to Fix Total Row is Displaying 0 Instead of Real Sum"},"content":{"rendered":"\n

Sample problem:<\/strong><\/p>\n\n\n\n

I have employee data, which I used to create a table with headcounts and a measure of % Female:<\/p>\n\n\n\n

\"Summary<\/figure>\n\n\n\n

The tricky part is when I want a count of how many countries have % Female >= 30%. I added a measure:<\/p>\n\n\n\n

Meets Criteria<\/strong> =  IF ((Female HC]\/ [Total HC]) >= 0.3, 1, 0)<\/p>\n\n\n\n

It works fine in the table, but the total is 0, when it should be 2. <\/p>\n\n\n\n

Solutions:<\/strong><\/p>\n\n\n\n

Create below two measures. The first one is for female proportion per country and the second one is for the count of countries where female proportion is greater than equal to 0.30. <\/p>\n\n\n\n

_femaleProportion = \nVAR _female = CALCULATE(SUM(Headcount[Female HC]),ALLEXCEPT(Headcount,Headcount[Country]))\nVAR _total = CALCULATE(SUM(Headcount[Total HC]),ALLEXCEPT(Headcount,Headcount[Country]))\nRETURN DIVIDE(_female,_total,0)\n\nFinalResult = CALCULATE(DISTINCTCOUNT(Headcount[Country]),FILTER(Headcount,[_femaleProportion]>=0.30))<\/code><\/pre>\n\n\n\n
Ref: https:\/\/community.powerbi.com\/t5\/DAX-Commands-and-Tips\/Table-with-IF-function-totals-to-zero\/m-p\/846114#M6545<\/p>\n","protected":false},"excerpt":{"rendered":"
Sample problem: I have employee data, which I used to create a table with headcounts and a measure of % Female: The tricky part is when I want a count of how many countries have % Female >= 30%. I added a measure: Meets Criteria =  IF ((Female HC]\/ [Total HC]) >= 0.3, 1, 0) It Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,621],"tags":[1099,1100],"class_list":["post-3993","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-power-bi","tag-total-row-is-displaying-0-instead-of-real-sum","tag-total-row-is-displaying-0-instead-of-real-sum-in-power-bi"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t