Hi. This will depend on how you show your data in your visualization. Anyway, try this: NewMeasure = CALCULATE ( [avg_order_margin] , ALL( Query1[order date] ) ) The all should be for the whole division and not for each numerator and denominator. Hope this works,

ll you didn't mention you have a filter on the filter pane haha. This is calculating for the whole dates. To keep this idea on the visualization try ALLSELECTED() instead of ALL. Regards,

.. | Microsoft Fabric Community

4 Replies

ibarrau
Super User
6 years ago
Hi. This will depend on how you show your data in your visualization. Anyway, try this:

NewMeasure = CALCULATE ( [avg_order_margin] , ALL( Query1[order date] ) )

The all should be for the whole division and not for each numerator and denominator.

Hope this works,
- Anonymous
  Not applicable
  6 years ago
  .
  - ibarrau
    Super User
    6 years ago
    ll you didn't mention you have a filter on the filter pane haha. This is calculating for the whole dates. To keep this idea on the visualization try ALLSELECTED() instead of ALL.
    
    Regards,

Forum Discussion

..