Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have below DAX, it does not show the total, I would like to show the total regardless of the visual, I will be using this measure in calculation of other measures:
@Anonymous , because you have used hasonevalue and grand total does not have one
you can try a new measure like. or add this return value
Sumx(Values(Location[County]) , [Budget2 Volume Target])
Thanks, it worked.
I tired to do it all in one measure, but did not work, like below:
Budget Volume Target =
VAR CapVic = CALCULATE
(CALCULATE(
SUM('KPI Target'[Value]),
FILTER( 'KPI Target','KPI Target'[Target Code] ="BUDGET VOL"
&& 'KPI Target'[Dimension 2 Value] = ">CAP"),
ALLEXCEPT('Posting Date', 'Posting Date'[Date])
),
CROSSFILTER('KPI Target'[LocationLookupKey], Location[LocationLookupKey], None)
)
VAR BugdetVolAll = CALCULATE(
SUM('KPI Target'[Value]),
FILTER( 'KPI Target','KPI Target'[Target Code] ="BUDGET VOL"
&& 'KPI Target'[Open] =1))
VAR AllTarget=
IF(HASONEVALUE(Location[County]),
IF(VALUES(Location[County]) = "VIC",
CapVic + CALCULATE(BugdetVolAll, FILTER( 'KPI Target','KPI Target'[Open] =1)),
CALCULATE(BugdetVolAll, FILTER( 'KPI Target','KPI Target'[Open] =1))
)
)
Return
SUMX(VALUES(Location[County]), AllTarget)
Do you kno why?
Hi @Anonymous ,
Please view the video in the following link, you may get the answer from there.
Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand
Best regards
Rena
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |