Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I Have a measure that calculates the total count of circuits when expense does not = 0 and the max month is 202212 and the min month is 202201 as shown below.
I would like to add an additional filter based on a separate measure I created called profitability. The last filter would say "if Profitability is greater than 0" . How can I add this last part to my measure?
CALCULATE(DISTINCTCOUNT('ckt_list'[Circuit #]),
FILTER('ckt_list','ckt_list'[Expense]<>0),
FILTER('ckt_list','ckt_list'[max_month]="202212"),
FILTER('ckt_list','ckt_list'[min_month]="202201")
Solved! Go to Solution.
Try
My Measure =
CALCULATE (
DISTINCTCOUNT ( 'ckt_list'[Circuit #] ),
FILTER (
'ckt_list',
'ckt_list'[Expense] <> 0
&& 'ckt_list'[max_month] = "202212"
&& 'ckt_list'[min_month] = "202201"
&& [Profitability] > 0
)
)
Try
My Measure =
CALCULATE (
DISTINCTCOUNT ( 'ckt_list'[Circuit #] ),
FILTER (
'ckt_list',
'ckt_list'[Expense] <> 0
&& 'ckt_list'[max_month] = "202212"
&& 'ckt_list'[min_month] = "202201"
&& [Profitability] > 0
)
)