Getting (Blank) for calculated measure

[Anonymous]

Hello,

I have the following measure that is reporting (Blank) if I do not have 1 manufacturer selected. MFG PARTNER COUNT is a calcuated column while Manufacturer is a column in the data source table.

Measure = IF (

     HASONEVALUE('CATEGORY ACCESS'[MANUFACTURER]),

    COUNTX(ALLSELECTED('CATEGORY ACCESS'[MANUFACTURER]),

    CALCULATE((SUM('CATEGORY ACCESS'[MFG PARTNER COUNT])

    ))))

Any ideas?

@Amit Chandak ?

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[beeW]

@Anonymous  I might need more context to help.  Some ideas:

1. Do you have anything set on page filters that maybe impacting your expected result ? 
2. To debug further does separating out the CALCULATE((SUM('CATEGORY ACCESS'[MFG PARTNER COUNT]) into its own measure give you the result expected to try to pin-point why not working how you expect ?