Forum Discussion
Solved
Remove rows based on condition
Hi, I need to calculate the average unit selling price (AUSP) based on the condition below. Sample pbix here. If the total revenue of last year = 0 or total revenue of current year = 0, keep the ro...
Hi PBI_newuser ,
Please modify this formula ：Current Year.
Current year = VAR result1_ = SUMX ( FILTER ( ALLSELECTED ( 'Append Table' ), 'Append Table'[next_count] = BLANK () && 'Append Table'[last_count] = BLANK () && [min_] = 3 && 'Append Table'[Fis] = SELECTEDVALUE ( 'Calendar'[Fiscal Year] ) ), [Revenue Current Year] ) RETURN result1_Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi PBI_newuser ,
Please modify this formula ：Current Year.
Current year =
VAR result1_ =
SUMX (
FILTER (
ALLSELECTED ( 'Append Table' ),
'Append Table'[next_count] = BLANK ()
&& 'Append Table'[last_count] = BLANK ()
&& [min_] = 3
&& 'Append Table'[Fis] = SELECTEDVALUE ( 'Calendar'[Fiscal Year] )
),
[Revenue Current Year]
)
RETURN
result1_
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous , how to fix the "Current year" and "Last year" measures if only one Fiscal Year is selected? The result for "Current year" and "Last year" changed when FY2020 is not selected.
The ultimate goal is for user to select one Fiscal Year to see the current year and last year result. Here is the sample.
