Forum Discussion

dapperscavenger's avatar
dapperscavenger
Icon for Helper V rankHelper V
2 years ago

Sumx with filter on dynamic measure

Hi!   I have a table which shows me the volume in the number of shipping containers expected to be needed (forecast data).  The 'current shipping' field tells me the current strategy we are using t...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

dapperscavenger's avatar
dapperscavenger
Icon for Helper V rankHelper V
2 years ago

Never mind, I am an idiot.  It was the easiest filter formula ever.  (which I thought I had tried earlier but honestly maybe I had one too many mince pies this christmas because my brain has turned into mince)

 

Fcst Cont Rec =
 CALCULATE([Fcst Cont], FILTER(FactData, [Rec Shipping] = "FCL"))