Hi all,
The count of records applied to the specific condition is 19 and I confirmed that the count is the same when I filtered the table imported to the dashboard by applying the same filters for the condition.
However, when I tried to display this value in an Advance Card, it displayed 20 instead of 19. The subsequent calculations involving this value is calculated with 20, not 19.
Has anyone had similar issues or know what the issue may be?
Thanks!
Comments
-
v-xiaoyan-msft
on:
Frequent "Cache.Key is denied" Refresh Failure on ...
- mrmossevig on: Fabric Capacity App fails to load with 'An error o...
-
v-yetao1-msft
on:
Something went wrong endless loop
-
v-xiaoyan-msft
on:
Slicer bug?
-
Element115
on:
BUG::SLICER::IDbConnection interface
- spindive on: Possible Bug with Rounding
-
v-xiaoyan-msft
on:
export to excel
-
v-xiaoyan-msft
on:
Is there any way to see the full name of the colum...
- Lingaraj-Mishra on: Issue with Client Credentials Grant Type for Power...
- MattSwan on: Multi-Select Possible in Filter Panel even when Re...
When you have filtered columns in the data view, it will not reduce the actual data size in Power BI, the filter in the data view is used for users to find the specific data easily, so if the table row has 20 rows and you have filterd 19 rows, the visual will still show the count of the table as 20 instead of 19.
If you want to filter the column values indeed for the data model, you need to filter it in Power Query editor before you load data into Power BI Desktop.
Best Regards,
Community Support Team _ Yingjie Li