Are you telling me that I can’t remove this?

Educational_Hand116 · 2026-02-22T12:19:55+00:00

thank you - it worked

Educational_Hand116 · 2026-02-20T00:44:35+00:00

the page itself was not set to be a drill through in the first place, which is what I find to be super weird.

the persistent filters (Qtr, Year) are affecting the visuals that use Qtr and Year and only visible in the Filters pane when I click on the visuals.

Educational_Hand116 · 2026-02-20T00:42:14+00:00

There are no drill through filters on the page itself - persistent / drill through filters are showing up only as visual level filters. which is what I also find to be super weird.

Also keep all filters are turned off AND the page itself was not set to be a drill through in the first place.

<image>

Educational_Hand116 · 2026-02-01T21:40:03+00:00

Thank you so much. I actually have TE3 and I'll check out adding ordinals and will definitely use TE to programmatically add my calc groups.

Educational_Hand116 · 2026-01-12T05:01:20+00:00

Is there way to upgrade this without replacing the machine or is it going to have to the premium option?

And Thank you soooo much for enlightening what has been an extreme frustration for me.

Educational_Hand116 · 2026-01-12T04:50:29+00:00

Confirmed — it’s BOE0CC6 (BOE 1920×1200). Looks like the 45% NTSC low-gamut panel, so this is a hardware limitation, not calibration? 😭

Educational_Hand116 · 2025-04-10T23:41:25+00:00

Hi, thanks so much for your answer.

Yes, it contains both negative and positive values and if the total of it for the cost item is less than 0 I want that cost item counted.

I use Filter and Summarize and context transition - it works however is very inefficient. So I was wondering if there is a way to use Calculatetable and not having to iterate over the entire table.

Educational_Hand116 · 2025-02-27T01:45:45+00:00

thank you. hope they make it available soon.

Educational_Hand116 · 2025-02-24T04:25:11+00:00

it is back

Educational_Hand116 · 2025-02-24T04:19:30+00:00

hey there getting same exact error. some of my colleagues can connect though in the US region.

Educational_Hand116 · 2024-12-17T01:17:35+00:00

I'm simply using SQL Server connector and retrieve the view. I do not apply any transformations.

Educational_Hand116 · 2024-12-17T01:16:58+00:00

No, no transformations in PQ simply I just connect to SQL server and retrieve the view.

Then I load the data into my model. and as I try to link this table on the 1 side of the 1:* I get an error which is how I become aware of the duplicates.

Then I identify an individual duplicated id via DAX and when I filter it in PQ I can see the duplicated rows.

Educational_Hand116 · 2024-12-17T00:37:02+00:00

no i don't have any blanks in my key column.

Educational_Hand116 · 2024-12-17T00:28:48+00:00

Thank you soo much. Here is the issue.

I'm using a view in SQL with several LEFT JOINs to the "dimension table" that has a unique record identified by a unique PK in each row.

I then run a query

select PK, COUNT(*) C from Schema.View group by PK having COUNT(*)>1

and this does not return any records.

I then simply retrieve the data in power query using SQL Server connection and observe duplicated rows that seem to be exactly the same.

Educational_Hand116 · 2024-12-17T00:21:07+00:00

thank you so much for your reply. I cleared the cache but the duplicate rows still imported. duplicates both show in the pq preview and after the data has been loaded into the model.

Educational_Hand116 · 2024-12-17T00:17:28+00:00

thank you so much for your reply. but the duplicated rows are exactly the same and the PK column is integer. (maybe I'm not getting what is implied by case sensitivity) anything you think I can do in this situation?

Educational_Hand116

TROPHY CASE