Display count of dimension values without using measures or calculated fields

[Bend-IT]

I would like to create a Card visual that displays a count of filtered values. I would like to do this without creating extra measures or calculated fields/tables, as end users (with limited knowledge) should be able to understand and follow along.

Example:

I have a table 'Products' with 3 records:

ProductID	ProductName
1	Chair
2	Table
3	Stool

and table 'Product Weights' with 3 records (in my case the 'ProductWeight' field is used as a measure):

ProductID	ProductWeight
1	4
2	5
3	6

I want to create one Card visual that displays the total count of products (3), and one that displays the count of products with price < 5 (1). Unfortunately, it is not possible to apply a filter to a measure before the values are aggregated (counted).

Does anyone have suggestions on how to achieve this? I am open to using other kinds of (third party) visuals.

[Anonymous]

Hi  @Bend-IT ,

You can first go to query editor>filter "weight is less than 5":

Then go back to Report view>create a card view>put the weight column inside>right click on the field,choose:count;

And you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Bend-IT]

And how would you go about showing the other card (with '3') at the same time? Without sketchy workarounds such as duplicating the query?

I have a strong feeling this is not possible. I think I'll submit an idea to enable us to filter data before it's aggregated. 

[Anonymous]

Hi  @Bend-IT ,

Using query editor in your case will be a little limited,and dax should be a best solution for you,if you donnt wanna use dax ,you can create  a support ticket via below link and our relevant personnel will help to handle it.
https://powerbi.microsoft.com/en-us/support/

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Bend-IT , Is these option not working?

calculate(count(Table[ProductID ]),Table[ProductWeight]<5)

Or
calculate(count(Table[ProductID ]),filter(Table,Table[ProductWeight]<5))

[Bend-IT]

Thanks for your reply, but your solution can't be used unfortunately because it requires the user to know/use DAX.