Required help in visualization

[Bansi008]

Hi there,

I am using card visual in the PowerBI visualization pane, and field what I selected is stocks name and converted it into count. since in the foundational table I have records like account level, aggregated value and issuer level along with stocks names, the count value is appearing incorrectly in the visualization. since it is counting account level, aggreagated value and issuer level records as well, despite I have filtered related table only with stocks names and removed these records.

How would I get the correct count of stocks in the card visualization?

[VijayP]

@Bansi008  

CALCULATE(
COUNT(tblOutput[Security Issuer Name])
,KEEPFILTERS( 
           NOT tblOutput[Security Issuer Name] IN { "Fund Level" ,"Issuer Level", "aggregated value"))

That should work

[Bansi008]

@VijayP thanks Vijay. let me try this solution

[VijayP · Accepted solution]

@Bansi008 

You are using implicit calculation hence this will take all. Filter within power bi Model will not help. It should be filtered out at power query level.

to get the result in power bi model you have to get the count with explicit measure

calculate(count(column), filter(table,column = what you want to see) or <> what you donot want to see

[Bansi008]

@VijayP In the table view of dashboard, I am using new measure to calculate the count using your formula but seems like it is not correct. Can you please confirm if I am using right syntax.
Can you please help if my syntax is correct or I am making any other mistake.  

New Measure = CALCULATE(COUNT(tblOutput[Security Issuer Name],FILTER(tblOutput,tblOutput[Security Issuer Name]<>Fund Level, Issuer Level, aggregated value)