How to display a unit count and a fact table in a page

[akhaliq7]

Intro: Hi I need to display a fact table and a unit count in the same page

Background: Before I used to use a card to display the unit count and have the fact table shown just below. I used to hide the visual level filters and show only the page level filters but this method at times is not as accurate as I would like. As sometimes I need to display a sum of units which include sales and cancellations

Question: what would be the best way to go about creating the unit count?

Options: have it in a table as a measure showing the unit count (summarized), this way I can turn on visual level filters.

Or if anyone has some experience in thise area advice would be highly appreciated.

[v-yiruan-msft · Accepted solution]

Hi @akhaliq7 ,

You can create a measure as below and put it on card visual.

Measure = COUNT ( 'tablename'[fieldname] )

In addition, you can refer the following links to achieve your requirement.

Power BI Card – How to Use + Examples

How to use the “COUNT” function in Power BI?

Add a filter to a report in Power BI

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards