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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
ovonel
Post Prodigy
Post Prodigy

Why these 2 measures give a different total?

I have only these 2 measures in a visual:

ovonel_0-1633004812982.png

 

Measure 1:

VAR V1=
ADDCOLUMNS(
VALUES (Fact[Key_Customer] ), 
"C1",             
CALCULATE([RevenueYTD],SAMEPERIODLASTYEAR('Date'[Date]),REMOVEFILTERS(Fact[Segment],Fact[Type])
)  
)

RETURN SUMX(V1, [C1])

 

 

Measure 2:

CALCULATE ( [RevenueYTD], SAMEPERIODLASTYEAR('Date'[Date]) )

 

I use Measure 1 mostly, because I am preventing certain splits, that I prefer grouped by Customer….

 

My question is: why do I get 2 different TOTALS?

ovonel_1-1633005067956.png

(I expected to see the totals as exactly the same. For the above case; I have no filter, its just a clean matrix visualization with both measures as ‘Values’!)

1 REPLY 1
dedelman_clng
Community Champion
Community Champion

Hi @ovonel -

 

Hard to tell specifically without the model, syntax for [RevenueYTD] or any data, but at first glance you do a REMOVEFILTERS in the first one and not on the second one. 

 

Hope this helps

David

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Kudoed Authors