Forum Discussion

caloyboy81's avatar
caloyboy81
Regular Visitor
8 years ago

CALCULATE with COUNT filter.

Hi Power BI Community, I have been using Power BI Desktop for a while now but quite new to DAX. I have what looks like an easy problem but I can't seem to make it work despite looking through differ...
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi caloyboy81,

 

Please modify above measure as:

Desktop WO 1 =
CALCULATE (
    DISTINCTCOUNT ( WO[SN] ),
    FILTER (
        WO,
        CALCULATE ( COUNT ( WO[Work Number] ), ALLEXCEPT ( WO, WO[Model], WO[SN] ) ) = 1
            && WO[Model] = "Desktop"
    )
)

Best regards,

Yuliana Gu

caloyboy81's avatar
caloyboy81
Regular Visitor
8 years ago

Hi Yuliana,

Thanks for writing back. I can't seem to make the DAX return the correct value. I'll try to create a new pbix with the sample data in the coming days.

 

The number of devices that should be returned by the measure is not what I was expecting.