Forum Discussion
Not Getting a total on table visual
I created the following dax measure, but not able to see the total for it when using it on a table, Also getting a blank value when used on card visual.
Hi Greg_Deckler ,thanks for the quick reply, I'll add further.
Hi Anonymous ,
Regarding your question, 'Total' has no filtering effect. Since you are also using the 'selectedvalue' function, the function returns null.
Try to modify your expression.
Measure = VAR _a = SELECTEDVALUE('Table'[Date]) VAR _b = SWITCH(TRUE(), YEAR(_a) = 2024,SELECTEDVALUE('Table'[Amount])) RETURN IF(ISBLANK(_a),CALCULATE(SUM('Table'[Amount]),YEAR('Table'[Date]) = 2024),_b)
May =
SWITCH (
TRUE (),
YEAR ( SELECTEDVALUE('Open Opportunities'[Est. close date]) ) = 2024, SELECTEDVALUE('Open Opportunities'[Estimated Revenue]),
0.00
)
By using this measure I am getting a $0