Dear @HimanshuSingh-lk2my, Thank you for your question. We appreciate your feedback. Regarding your question on how to get a distinct count while ignoring blanks in Power Pivot. Certainly, it’s possible in Power Pivot, just use the formula below and check the Excel file linked to this message. In the Power Pivot window, select the cell where you want the distinct count. Enter this formula in the formula bar, and press ENTER. DistinctCountIgnoringBlank:=CALCULATE(DISTINCTCOUNT(Range[Score]),NOT(ISBLANK(Range[Score]))) This will return the distinct count, ignoring the blanks. Excel file: www.exceldemy.com/wp-content/uploads/2024/01/Count-Distinct-Values-Ignoring-Blank-Using-Power-Pivot.xlsx Make sure to stay connected with ExcelDemy! 🎉❤. Have a good day. Regards, ExcelDemy
In power pivot how to get accurate distinct count as blank is also counted as 1
Dear @HimanshuSingh-lk2my,
Thank you for your question. We appreciate your feedback. Regarding your question on how to get a distinct count while ignoring blanks in Power Pivot. Certainly, it’s possible in Power Pivot, just use the formula below and check the Excel file linked to this message.
In the Power Pivot window, select the cell where you want the distinct count. Enter this formula in the formula bar, and press ENTER.
DistinctCountIgnoringBlank:=CALCULATE(DISTINCTCOUNT(Range[Score]),NOT(ISBLANK(Range[Score])))
This will return the distinct count, ignoring the blanks.
Excel file: www.exceldemy.com/wp-content/uploads/2024/01/Count-Distinct-Values-Ignoring-Blank-Using-Power-Pivot.xlsx
Make sure to stay connected with ExcelDemy! 🎉❤. Have a good day.
Regards,
ExcelDemy