Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Visualization Summary

Hello Community,      I am a new PowerBI user. I have a table visualization with fields from three tables. I have verified that the results displayed are correct. I now want to count the number of ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    If i understand you correctly, ALLSELECT() function might be helpful for you.

    Please refer to the measures below and modify your measures.

    sum = CALCULATE(SUM('Table'[PotentialValue]),ALLSELECTED('Table'))
count = CALCULATE(COUNT('Table'[ID]),ALLSELECTED('Table'))

    Result would be shown as below.

    BTW, since the filters you used are visual level filter, they can't affect other views such as SUM and COUNT above.

    Instead, you can use page level filter if you want.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

az38's avatar
az38
Community Champion
6 years ago

Anonymous 

create 2 new measures

1.

MeasureCount = calculate(count([Handoff ]);ALL('Table'))

and

MeasureSum = calculate(sum([PotentialValue]);ALL('table'))

then add this measures to table visual and set Do not aggregate

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

   I tried your suggestion. I was unable to use the syntax you provided in its entirety. The ;ALL('Table') did not work for me. I did create the measure in the image below and added it to my table.

 

 

It qadded a new column with the number 1 for each row and added each row to my results, thus I have a total of 1741 rather than the 7 I need. What I would like to do is just be able to count the returned results. Using my prior image, I would like the Total to appear at the bottom with the number 7 under Handoff and 125,000 under the Potental Value column.

 

Peter

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Anonymous 

    what do you mean "The ;ALL('Table') did not work for me"?what kind error do you see?try to replace ";"to ",". it depends on localization

    and why count should be 7 if i see scrollbar and 8 ros as minimum in visual

    you could share your pbix-file to https://uploadfiles.io/ for example

    do not hesitate to give a kudo to useful posts and mark solutions as solution