Forum Discussion
DAX - Fetch distinct sum when relationship is undefined
Hi, I have a two tables Forecast Table which has multiple forecasts for a given quarter +------------+------------+------------+-----------+
| Fiscal Qtr | Type | Category | Revenue ...
Hi Anonymous ,
Check the measure.
Measure = CALCULATE(SUM(Actual[Revenue]),FILTER(Actual,Actual[Fiscal Qtr]=SELECTEDVALUE(Forecast[Fiscal Qtr])&&Actual[Category]=SELECTEDVALUE(Forecast[Category])))Best Regards,
Jay
Hi Anonymous ,
Check the measure.
Measure = CALCULATE(SUM(Actual[Revenue]),FILTER(Actual,Actual[Fiscal Qtr]=SELECTEDVALUE(Forecast[Fiscal Qtr])&&Actual[Category]=SELECTEDVALUE(Forecast[Category])))
Best Regards,
Jay