1. There are 3 tables (Calendar table, Merch_Forecast_snapshot table, Article table) and also have relationship. 2. we brought the columns cal date month, Le month index from Calendar table by using related dax function to the Merch forecast_snapshot table. 3. I shared table details ...
An unexpected error occurred (file 'xmtwdatacache.cpp', line 2719, function 'XMWindowingIterator::Init'). Query Text: EVALUATE UNION(CALCULATETABLE ( TOPN ( 3, DISTINCT ( SELECTCOLUMNS ( TOPNSKIP ( 30, 0, 'Requisition Measures' ), "RelationshipId", 6873, "MissingValue", 'Requisition Measure...
You should be able to improve what you have by removing the RELATED functions. You already have an active ONE:MANY relationship in place, and you're not trying to actually bring any values across the relationship, so you shouldn't need this at all. Just 'DIM - Status'[Status] = "...
I also don't understand this part of your function so thought I'd best check FILTER( SoleClients, "Active" IN { SoleClients[ActiveStatus], RELATED( Clients[ActiveStatus] ) } ) There is no existing column SoleClients[ActiveStatus] I can add in but not sure what it means. I have anoth...
I just somehow want to replace AVERAGEX() with some other function. AvgColumn1:= AVERAGEX(KEEPFILTERS(VALUES('viewUser1'[UId])),CALCULATE(DISTINCTCOUNT('viewUser1'[ApplicationId])) Message 9 of 11 1,013 Views 0 Reply Greg_Deckler Super User In response to jatneerjat 09-26-2018...
I just somehow want to replace AVERAGEX() with some other function. AvgColumn1:= AVERAGEX(KEEPFILTERS(VALUES('viewUser1'[UId])),CALCULATE(DISTINCTCOUNT('viewUser1'[ApplicationId])) Message 9 of 11 1,013 Views 0 Reply Greg_Deckler Super User In response to jatneerjat 09-26-2018...
I just somehow want to replace AVERAGEX() with some other function. AvgColumn1:= AVERAGEX(KEEPFILTERS(VALUES('viewUser1'[UId])),CALCULATE(DISTINCTCOUNT('viewUser1'[ApplicationId])) Message 9 of 11 1,025 Views 0 Reply Greg_Deckler Super User In response to jatneerjat 09-26-2018...
Can take a look at seeing how to perhaps optimize your DAX, but would probably be much more successful if we had a sense of your source data and what you were trying to accomplish. That way we could recreate it and test out some different approaches. Please see this post regarding How ...
I just somehow want to replace AVERAGEX() with some other function. AvgColumn1:= AVERAGEX(KEEPFILTERS(VALUES('viewUser1'[UId])),CALCULATE(DISTINCTCOUNT('viewUser1'[ApplicationId])) Message 9 of 11 1,025 Views 0 Reply Greg_Deckler Super User In response to jatneerjat 09-26-2018...
I just somehow want to replace AVERAGEX() with some other function. AvgColumn1:= AVERAGEX(KEEPFILTERS(VALUES('viewUser1'[UId])),CALCULATE(DISTINCTCOUNT('viewUser1'[ApplicationId])) Message 9 of 11 1,025 Views 0 Reply Greg_Deckler Super User In response to jatneerjat 09-26-2018...