Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX Formula

Hi Team,

 

Requesting your assistance on this.

 

I'm new on PowerBI and I'm trying the 624.32 to be seen on the blank and not only on the total. Please see screenshot (Column AB)

 

My formula is 

AB = IFERROR( [CA Dradis Total Audit Volume] / DISTINCTCOUNT('Summarized QA - Dradis'[Evaluator LDAP]), BLANK())
 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    To me it looks like your two measures does not return values in the filter context of the row.

    Try to add them in the table in see their value. 

    They work only in the total. To understnad why, you need to check the model

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Not 100% clear what you are looking for, but first thing would be use the DIVIDE function especially in your [AC] so that you dont have that Infinity in there.

     

    From there, could you upload some sample data?

  • novilpawar's avatar
    novilpawar
    Advocate I
    7 years ago

    Hi@Tungogers 

    Please try below Dax

    AB = DIVIDE( [CA Dradis Total Audit Volume] ,DISTINCTCOUNT('Summarized QA - Dradis'[Evaluator LDAP]), 0)

     

    Regards

    Novil