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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
NickoliTesla
Regular Visitor

Report Builder - Inconsistent measure behavior

Hi all,

 

I am needing to create a paginated report based on a tabular model. Lucky for me I have already created this report in PBI Desktop and confirmed all my measures are working as expected.  


PBI Desktop measure testing: 
First set are in folder "transaction currency", second set in folder "local currency"

EX 1.png

 

However, when I start querying from PBI Report Builder the "Local Currency" measures are returning null.  

Net Value = "NetAmount_LWD_LCY_GSI" & Value = "GrossAmount_LWD_LCY_GSI"

EX 2.png

The measures are near identical in tabular: 

Local Currency

NickoliTesla_0-1702407446561.png

Transaction Currency

NickoliTesla_1-1702407473001.png

 

Notice they are based on different measures. This is where it starts getting weird. 

GrossAmount_LCY_GSI does not show up null in report builder

NickoliTesla_2-1702407727740.png

Here is the dax for this measure:

NickoliTesla_3-1702407761509.png

However, notice that NetAmount_LCY_GSI and DiscountAmount_LCY_GSI are both null in that same image where GrossAmount isn't null? How is this possible? 

I hope this all makes sense, here is a list of the measures in tabular to help make sense of this:

EX 3.png


If there is any additional info needed please let me know. I'm at my wits-end with this. 

 

Thanks!

 

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.