Showing distinct count of values in a colum

[ahsanlhcgov]

I have a table as below. the column lostoppo is a measure with formula 

LostOppo = CALCULATE(COUNT(vBIOppoFunnel[Opportunities]), FILTER(vBIOppoFunnel, vBIOppoFunnel[Opportunity Stage]="Lost"))

the values are not distinct in the column. I am trying to get distinct values which have the opportunity_stage as lost.

at the end I would like to have the percentage of the lost opportunities with the total number of opportunities for that framework. 

please can anyone help me with it.

 

[v-caliao-msft · Accepted solution]

Hi @ahsanlhcgov,

I have tested it on my local environment, I can use DistinctCount without any issue.

Count = CALCULATE(COUNT(Sheet6[Category]),FILTER(ALLEXCEPT(Sheet6,Sheet6[Group]),Sheet6[Type]="T"))

DistinctCount = CALCULATE(DISTINCTCOUNT(Sheet6[Category]),FILTER(ALLEXCEPT(Sheet6,Sheet6[Group]),Sheet6[Type]="T"))

So in your scenario, please check if you DAX is correct or not. If the issue persists, please provide us more details, so that we can make further analysis.

Regards,

Charlie Liao

[ahsanlhcgov]

I have tried using distictcount but breaks the visual with error

Invalid column name. the exception was raised by the IDbCommand interface