Why rankx function shows duplicated rank?
Hello, I am using this 1 dax in order to rankx my resource groups: Rank (Selected Category) = VAR cat = SELECTEDVALUE ( Fct_EA_AmortizedCosts_Daily[ResourceGroup] ) RETURN IF ( NOT ISBLANK ( cat ), VAR r = RANKX ( ALL(Fct_EA_AmortizedCosts_Daily[ResourceGroup]), -- ignore slicer on category [Total Amortized Cost], , DESC, Dense ) RETURN IF ( r <= 5, r, 6 ) ) and without any selection my ranked is duplicated: Why? If this is a matter of duplicated rows in fct amortized table? Best, Jacek
Handling multiple Fact Tables with different Aggregation
Dear Community, I have 2 dim and 2 fact tables with the following model: So the problem I get is in vizulising both fact values in one Visual without grouping (don't want to MAX or SUM the BookingDate or costs). Here the Name "abc" should get 30 sales and three different costs and the other Names ("def" and "ghi") should get 30 and 15 sales and no costs (tables on the right). But as you can see the Visual showing all the values of both fact tables without any relationship (table in the middle): I would expect this: Does somebody has any Idea? Thanks in advance!
A fact table getting info from dimension table and fact table then grouping & distinct count
Hi , My scenario is 2 fact tables (point & trans) connecting to a dimension table (profile) point table is filtered by calendar table (e.g. 3-Aug-2023 to 4-Aug-2023), there are 124 members with this date selection a. getting the regist date of these 124 members from profile table b. getting the last order date from trans for these 124 members from trans table 1. when regist date of member >= 3-Aug-2023, would call this member group as Group A and get the distinct count of the members 2. when regist date of member < 3-Aug-2023 and last order date >= 3-Aug-2022, would call this membes group as Group B and get the distinct count of the members 3. when regist date of member < 3-Aug-2023 and last order date < 3-Aug-2022, would call this member group as Group C and get the distinct count of the members 4. when regist date of member < 3-Aug-2023 and last order date is null, would call this member group as Group D and get the distinct count of the members have written 2 measures [_Last_Order_Date], [_Last Order Date (for points member)] about this, but not sure how to proceed for [_Historical Purchase Group Count] have uploaded pbix file to onedrive , could anybody help to get this work? fact-bridge-fact.pbix
