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
I have only these 2 measures in a visual:
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?
(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’!)
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
34 | |
14 | |
12 | |
11 | |
10 |