Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gmooney100
Helper I
Helper I

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 ?
2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

Share some data and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
beeW
Regular Visitor

@gmooney100  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 ?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.