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 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.