Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Wrong Count Distinct result in Power BI

Hi,   I want to simply calculate the total number of PurchaseOrderId in Power BI Desktop as per my below example, but the result gives me a wrong count.   Here is the settings in the below table:...
Need Help
Thennarasu_R's avatar
Thennarasu_R
Icon for Responsive Resident rankResponsive Resident
3 years ago

Use instead of distinctcount to Max Inside if 

IF(MAX([PurchaseOrderId])=BLANK(),0,
DISTINCTCOUNT([PurchaseOrderId]))
  • YuvaSandiya's avatar
    YuvaSandiya
    New Member
    3 years ago

    It doesnt work. Still same issue