Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I'm starting to freak out about the following problem.
I have a model with just 2 tables.
Dim table contains 2 identical columns (initiative Category and Copy initiative Category)
When I create a table visual with each of these columns, and use identical metrics, I get a different result....
When I use the initiative Category column, the filter does not override to "Strategic"
if I use any other column from the dim table, everything behaves normally - the filter is always overwritten and I get the same value 6 times.
Any ideas? Is it kind of known bug? I would be grateful for any advice...
I've tried: refresh, delete cache, publish to service - still the same result...
Thank you.
are you able to share some sample data?
also have you profiled the data in the table to make sure it is exactly the same?
Proud to be a Super User!
Do you have a sort by column set for initiative category but not for the copy? If so, you could amend the 2nd measure to
My Measure =
CALCULATE (
SUM ( 'Fact table'[worklog hours] ),
REMOVEFILTERS ( 'Dim table' ),
'Dim table'[initiative category] = "Strategic"
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |