COUNT/COUNTROWS return 0 instead of blank
Hello, I am currently have an issue with count/countrows. When they evaluate and return nothing it shows blank instead of 0. I have 2 tables, a calendar table and a fact table with 10 rows. I am trying to calculate the percentage of colum ORIT = "Y". Lines ORIT2 = var _orit = CALCULATE(COUNTROWS(dataVN),dataVN[ORIT]="Y") return if(ISBLANK(_orit),0,_orit) The result is this. I don't want those extra lines that mean nothing. The manufacturing data field comes from the calendar table. How can I avoid this situation and get the desired result? The .pbix file is in this link if you want to try - https://we.tl/t-bHGwtdUf5d Thank you. André
Suppress 0 in Field Parameters
Hi guys, just wondering if you can help me with this... I created a field paramter based on two measures and added a bar-chart which now shows a lot of 0 values. In the filter pane I tried to exlude 0 and or blanks etc but it doesn't work as it will hide the content of the other field parameter. Example below: Dax Measure that causes the problem is the following: I tried both versions, but it does not change the outcome of the output. Admin = [Total Inspections]-[Physical] or Admin = IF ( ISBLANK ([Total Inspections] ), BLANK (), ( [Total Inspections]-[Physical] ) ) Field Parameter: Physical/Admin Slicer = { ("Physical", NAMEOF('Power BI - Inspections'[Physical]), 0), ("Admin", NAMEOF('Power BI - Inspections'[Admin]), 1) } This only happens when the Admin Slicer is selected. I can choose to not select 0 in the filter pane, but that hides all the Physical values then when Physical is selected. Thanks for your help.
Coalesce replace Blank
For showing the count which replaces the Blank to 0 at the cart, I have been using the following dax query: Cases = var caseCount = DISTINCTCOUNT(DD_FLU_DEMOGRAPHIC[Case ID]) return IF(ISBLANK(caseCount), 0, caseCount) But the problem is it rounds up the count. For example, it shows 38560 as 40K. Would you please suggest any alternative? I tried with coalesce function but it does not work for the string type data (for example, Case ID ) Regards
