Forum Discussion

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
3 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 for a dateset. What I want is to run it conditionally meaning it either returns data or not doesn't event run.

 

Thanks

Need Help
  • parry2k's avatar
    parry2k
    3 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 )
)

     

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    3 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 )
)