Forum Discussion

NirH_at_BITeam's avatar
NirH_at_BITeam
Frequent Visitor
7 years ago

DAX - Better way to write a formula

Hi,   I use ISBLANK  a lot in one of my BI models and I wonder if there is a better and much more efficient way to write the below measure. I have many other measures that check first if the resul...
Data Modeling
Reports
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi NirH_at_BITeam, 

 

You can use Variable in the measure: 

 

Count Invoice Awaitng Approval OR Partially Approved =
VAR t =
CALCULATE (
COUNTX (
AllJobsData,
AllJobsData[Z02 Count Submitted Invc with NO ApprovedInvc OR Partial Approval]
),
FILTER (
AllJobsData,
AllJobsData[Z02 Count Submitted Invc with NO ApprovedInvc OR Partial Approval] = 1
)
)
RETURN
IF ( ISBLANK ( t ), 0, t )

 

Best Regards,
Qiuyun Yu 

 

 

  • NirH_at_BITeam's avatar
    NirH_at_BITeam
    Frequent Visitor
    7 years ago

    Not sure if this actually simplifies the formula but thanks anyway!

     

    NH