Forum Discussion
Display 0 value instead of BLANK values and RANK the total count and restrict only top 5 rows
amitchandak Thank you looking into this.
Since I was able to understand that there are no records for the Accounts for the respective quarters and hence it is coming as BLANK. Initially quarter column data was coming from the same table where I have the account column. Included a calender table and used the quarter info from there and along with that including COUNT('Account'[Number])+0 solved my issue.
First created a new _calender table as
_calender= CALENDAR(MIN('Account'[Opened]), MAX('Account'[Closed]))Added the calculated columns for quarter as :
Year Quarter = YEAR([Date]) & " " & "Q" & QUARTER([Date])Then created the table visual using this Year Quarter column. Which gave the necessary output for the respective quarters. Then created a measureCountvalue =IF(ISBLANK(COUNT('Account'[Number])), 0, COUNT('Account'[Number]))This was all the blanks got replaced with 0.Now kept the same RANK logic per my orignal post and it allowed me to restrict the data via filter for top 5 records.
amitchandak Thank you looking into this.
Since I was able to understand that there are no records for the Accounts for the respective quarters and hence it is coming as BLANK. Initially quarter column data was coming from the same table where I have the account column. Included a calender table and used the quarter info from there and along with that including COUNT('Account'[Number])+0 solved my issue.
First created a new _calender table as
_calender= CALENDAR(MIN('Account'[Opened]), MAX('Account'[Closed]))
Added the calculated columns for quarter as :