79482196

Date: 2025-03-03 21:40:43
Score: 1
Natty:
Report link

I'm just spinning something here and this might be an overly-simplistic approach, but what if you created a column for Running Total Calculation in DAX.

Then add a Result column with a simple logical test, i.e. if Running Total column is greater than 20 show Running Total, else show 0.

Then, on the table visual, set a Conditional Formatting rule on the Text Color to be the same as the background if the value of the DAX column is 0, or less than 20.

Here is a link to good solution for creating the Running Total Column Cumulative (Running) Totals in DAX

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Jay Babcock