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é
Count working days of running month [Friday is weekend only] & Days elapsed
Hi Experts, Please help me out! Struggling to create a measure which will return total working days of current month dynamically [please note, Friday is only weekend in my organization]. I would also want to exclude holidays. I have a calendar table [see scrrenshot], now I want to calculate two measures 1. Total working days of current month 2. Days Elapsed = First Date of current month - Today () -1 [Excluding weekends and holidays] Thans in advance Mamun
Sum visible rows in matrix visual
Hi, I have a matrix table, with multiple rows and values. I wanted to count number of products but the measure I wrote is not summing in the table nor in card visual. Rows are coming from 6 different tables. Count products = COUNTX(Metrics,[Request Quantity]) Some of the products repeat within the country and customer, but I want to count visible number of products. Also I tried to calculate the average of the Days past request date but it gives me very high number, so I suppose it takes data from the whole table and I wanted to have it only for the data from the table. Days past request date = DATEDIFF('Time - Requested By'[Requested By Date],TODAY(),DAY) Avg = AVERAGEA('Time - Requested By'[Days past request date]) I would appreciate any help.Count appearance of string in a comma-separated data column does not count values after the first co
I have two tables: Products table has a single column with one product per field: List table has several columns but the column I'm interested in has fields that can have as little as one product to as much as 17, all separated with a comma and no spaces in between: The issue I'm facing and need help with is to correctly count each product either, ideally as as a measure. I tried two measures but they both gave me an incorrect count of blanks; there are no blank values either table. What I found is that both measures count only the *first* value they find in the List column and then continue counting subsequent rows: How can I correctly count all values in each field from the List table and have zero "blank" counts? Thanks!
Create miscellaneous/other group using count below a threshold
I've got a Line and Stacked Column Chart (using this because of Pareto line). I used to create a measure "Count". Count = CALCULATE ( COUNTROWS ( Projects ), ALLSELECTED ( Projects ), VALUES ( Projects[Points] ) ) "Project[Points]" is the Shared axis and "Count" is the Column values. Now I want to use this measure and combine any calculated values below 3 into a miscellaneous/other group. So it would be removing "M" thru "g", and creating an "other", stacking them all together. I've been using power bi for about 2 months now. So the more steps explained the better. Thank you.Count Rows based on dynamic column value
Hi, I have a stacked bar chart with a line graph on and as a tooltip, I want to show the percentage value of each stack. I've tried various solutions, but to no avail. For example, for 2019, when I hover over the bottom stack, I want the tooltip to tell me that it represents XX% of uploads for non-partners that year. I've tried the solution below, but the latter part of the argument returns the total number of rows within the table, not the amount for each year. Percentage = DISTINCTCOUNT('Overview'[First_NID])/CALCULATE(DISTINCTCOUNT(Overview[First_NID]),ALLEXCEPT(Overview,Overview[First_Year]))
