Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Getting (Blank) for calculated measure

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 ?
Need Help

2 Replies

  • beeW's avatar
    beeW
    Regular Visitor
    3 years ago

    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 ?