Forum Discussion
Solved
Replace SELECTEDVALUE to something else
Hi All! i have this Dax: Gross USD = IF ( SELECTEDVALUE( 'db 2021'[Source]) = "Amazon", CALCULATE ( DIVIDE ( ( SUM ( 'DB 2021'[Gross USD] ) + SUM ( 'DB 2021'[Fee USD] ) ), COUNTROWS ( 'D...
Like Samarth said you should get the column as a suggestion. Are you using a measure now? If so you here is a completely new approach to this:
CALCULATE (DIVIDE (( SUM ( 'DB 2021'[Gross USD] ) + SUM ( 'DB 2021'[Fee USD] ) ),COUNTROWS ( 'Date' )),KEEPFILTERS ( 'Date'[Date] < TODAY () ),filter('db 2021','db 2021'[Source] = "Amazon"))+CALCULATE (DIVIDE ( SUM ( 'DB 2021'[Gross USD] ), COUNTROWS ( 'Date' ) ),KEEPFILTERS ( 'Date'[Date] < TODAY () ),filter('db 2021','db 2021'[Source] <> "Amazon"))The logic here is to use one calculate logic when customer is Amazon (include the fee there) and other when it is not.
Like Samarth said you should get the column as a suggestion. Are you using a measure now? If so you here is a completely new approach to this:
CALCULATE (
DIVIDE (
( SUM ( 'DB 2021'[Gross USD] ) + SUM ( 'DB 2021'[Fee USD] ) ),
COUNTROWS ( 'Date' )
),
KEEPFILTERS ( 'Date'[Date] < TODAY () ),filter('db 2021','db 2021'[Source] = "Amazon"))
+
CALCULATE (
DIVIDE ( SUM ( 'DB 2021'[Gross USD] ), COUNTROWS ( 'Date' ) ),
KEEPFILTERS ( 'Date'[Date] < TODAY () ),filter('db 2021','db 2021'[Source] <> "Amazon"))
The logic here is to use one calculate logic when customer is Amazon (include the fee there) and other when it is not.