Forum Discussion
Post ProdigyExclude Specific Category
Hi AllanBerces - you can create below logic to exclude the category to modify your Earned calculated column in Power BI and exclude a specific category . replace with your table and column names
Earned =
CALCULATE (
SUM ( 'Table 1'[Earned] ),
FILTER (
ALL ( 'Table 1' ),
'Table 1'[Week No.] = EARLIER ( 'Table 2'[Week No.] ) &&
'Table 1'[Year] = EARLIER ( 'Table 2'[Year] ) &&
'Table 1'[Trade] IN { "MECH", "CIVIL", "ELEC" } &&
'Table 1'[ColumnA] <> "CategoryToExclude" -- Add this condition to exclude the category
)
)Hope this works.
Super UserHi AllanBerces - you can create below logic to exclude the category to modify your Earned calculated column in Power BI and exclude a specific category . replace with your table and column names
Earned =
CALCULATE (
SUM ( 'Table 1'[Earned] ),
FILTER (
ALL ( 'Table 1' ),
'Table 1'[Week No.] = EARLIER ( 'Table 2'[Week No.] ) &&
'Table 1'[Year] = EARLIER ( 'Table 2'[Year] ) &&
'Table 1'[Trade] IN { "MECH", "CIVIL", "ELEC" } &&
'Table 1'[ColumnA] <> "CategoryToExclude" -- Add this condition to exclude the category
)
)
Hope this works.
Post ProdigyHi rajendraongole1 thank you for the help, working as in need
- rajendraongole1