Measure works in Desktop, but not in the published report

[hahl]

I have a card visual with the measure:

AtCapacity = IF(SELECTEDVALUE('PC'[Office])<>BLANK(),
CALCULATE(SUM('T'[AtCapacity])*DISTINCTCOUNT('Date'[Last Day of Work Week]),
FILTER('PCE', 'PCE'[Office]=SELECTEDVALUE('PC'[Office]))),

IF(SELECTEDVALUE('PC'[Region])<>BLANK(),
CALCULATE(SUM('T'[AtCapacity])*DISTINCTCOUNT('Date'[Last Day of Work Week]),
FILTER('PCE', 'PCE'[Region]=SELECTEDVALUE('PC'[Region]))),
SUM('T'[AtCapacity])*DISTINCTCOUNT('Date'[Last Day of Work Week])))

I have no issues in the Desktop file with this measure, however when I go to publish it displays as an X and says:
Couldn't load the data for this visual
Couldn't retrieve the data for this visual. Please try again later.

Any ideas how I can trouble-shoot this?

Thanks!

[v-frfei-msft]

Hi @hahl ,

Based on my test, I cannot reproduce your issue here using Power bi desktop version :  2.76.5678.541 64-bit (December 2019). Could you please update your desktop and check agian?

Or you can update your measure as below to have a try.

AtCapacity =
VAR office =
    SELECTEDVALUE ( 'PC'[Office] )
VAR region =
    SELECTEDVALUE ( 'PC'[Region] )
RETURN
    IF (
        office <> BLANK (),
        CALCULATE (
            SUM ( 'T'[AtCapacity] ) * DISTINCTCOUNT ( 'Date'[Last Day of Work Week] ),
            FILTER ( 'PCE', 'PCE'[Office] = office )
        ),
        IF (
            region <> BLANK (),
            CALCULATE (
                SUM ( 'T'[AtCapacity] ) * DISTINCTCOUNT ( 'Date'[Last Day of Work Week] ),
                FILTER ( 'PCE', 'PCE'[Region] = region )
            ),
            SUM ( 'T'[AtCapacity] ) * DISTINCTCOUNT ( 'Date'[Last Day of Work Week] )
        )
    )

If the issue still occur, kindly share your sample data to me to have a test  if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[hahl · Accepted solution]

Thank you for the detailed response - it looks like the issue is not with the measure but with my table relationships. 

[v-frfei-msft]

Hi @hahl ,

Has your issue been solved? If so kindly mark my answer as a solution to close the case. Thanks in advance. Any other question, feel free to let me know please.