Forum Discussion

Bansi008's avatar
Bansi008
Helper III
2 years ago
Solved

Required help in visualization

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 ...
Need Help
  • VijayP's avatar
    VijayP
    2 years ago

    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

VijayP's avatar
VijayP
Community Champion
2 years ago

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's avatar
Bansi008
Helper III
2 years ago

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)