Forum Discussion

Markzolotoy's avatar
Markzolotoy
Impactful Individual
2 years ago
Solved

Run DAX expression conditionally

Let's say I have the following expression: EVALUATE SUMMARIZECOLUMNS('RealTimeServiceTypeSummary'[PointCount], 'RealTimeServiceTypeSummary'[RealTimeServiceTypeName]) This expression is a query fo...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    Markzolotoy try this:

     

     

    DEFINE
VAR __RunQuery = FALSE () --set value to TRUE () if you want to run the query
EVALUATE 
SUMMARIZECOLUMNS(
   'RealTimeServiceTypeSummary'[PointCount], 
   'RealTimeServiceTypeSummary'[RealTimeServiceTypeName],
   FILTER ( 'RealTimeServiceTypeSummary', __RunQuery )
)