Prompt Details
Model
(claude-4-6-sonnet)
Token size
302
Example input
[TableName]: Orders
[GroupColumn]: Region
[ConditionFilter]: FulfilmentStatus = Fulfilled
[Threshold]: 0.85
Example output
OrderFulfilmentCoverage =
VAR _Met =
CALCULATE(
COUNTROWS( Orders ),
ALLEXCEPT( Orders, Orders[Region] ),
Orders[FulfilmentStatus] = "Fulfilled"
)
VAR _Total =
CALCULATE(
COUNTROWS( Orders ),
ALLEXCEPT( Orders, Orders[Region] )
)
VAR _Pct = DIVIDE( _Met, _Total, 0 )
RETURN
IF( _Pct >= 0.85, "On Track", "Below Target" )
Instant access
Commercial use
Money‑backBy purchasing this prompt, you agree to our terms of service
CLAUDE-4-6-SONNET
Want to see what percentage of rows in each group meet a specific condition? This prompt generates a production-ready DAX measure that calculates coverage percentage per grouped entity, with a status label for above and below threshold. Works with any table, any grouping column, and any condition in Power BI.
...more
Added 3 weeks ago
