DAX Formula

[Anonymous]

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())

[Anonymous]

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

[novilpawar]

Hi@Tungogers 

Please try below Dax

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

Regards

Novil

[Anonymous]

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?