Forum Discussion
Count repeating values
Hi Lauraeire_81,
This is a classic case where you want a summarized count of food items filtered by slicer selections, but only showing one row per food item with the total count. This should not be done using a calculated column. Instead, you should use a measure and build a visual table that responds to slicers.
Food Count =
CALCULATE(
COUNTROWS(FoodTable),
ALLEXCEPT(FoodTable, FoodTable[Food])
)
Add a table visual:
- Put Food in the rows.
- Add the Food Count measure in the values.
- Add Country to the slicer.
If this post helps to answer your question, please consider accepting it as a solution so others can find it more quickly when they face a similar challenge.
Proud to be a Microsoft Fabric community super user
Let's Connect on LinkedIn
Subscribe to my YouTube channel for Microsoft Fabric and Power BI updates.
Hi Lauraeire_81 This could be achieved by creating a DAX measure like:
Food Count =
CALCULATE(
COUNT('FoodData'[Food]),
ALLEXCEPT('FoodData', 'FoodData'[Food])
)Add this measure to a table visual alongside the Food column. The slicer will dynamically filter the selected countries, and the measure will display the unique counts for each food item.