Hi Folks,

I’m having one of those days where my head is struggling to conceptualize DAX.

I need to create a measure where I have the Number of Occurrences * by the Cost Per Occurrence. So far, so straightforward. However, Occurrences are capped at 1000 per incident so the maximum cost will be 1000 * £50.00. Usually I’ll only have one row per Incident Number but occasionally they can be split over two or more rows so for INC588 it has two entries, one of 990 and one of 15.

Any help, as always is much appreciated.

Incident No | Occurences | Cost per Occurrence | Cost |
---|---|---|---|

Inc588 | 990 | £50.00 | £49,500.00 |

Inc588 | 15 | £50.00 | £750.00 |

Inc589 | 500 | £50.00 | £25,000.00 |

Inc590 | 10 | £50.00 | £500.00 |