Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have created a custom table using SUMMARIZECOLUMNS function:-
Tried with limited duration (1month) of data in Desktop and after publishing to PBI service increased the Data size using parameters & refreshed still getting same error.
Any kind of help will be appreciated.
Thanks & Regards,
Nidhi
@NidhiBhusari , can share Cummulative calculation
it should be like
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))
or
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))
@NidhiBhusari , Try like
Switch( True(),
ISINSCOPE('Rank Analysis'[BillToCustomer_Name]),CALCULATE (
[% of Total(GP)],
FILTER (all('Rank Analysis'),'Rank Analysis'[BillToCustomer_Name] <= MAX ('Rank Analysis'[BillToCustomer_Name]))),
ISINSCOPE('Rank Analysis'[CUSTOMER_PRACTICE_NAME]) , CALCULATE (
[% of Total(GP)],
FILTER (all('Rank Analysis'),'Rank Analysis'[CUSTOMER_PRACTICE_NAME] <= MAX ('Rank Analysis'[CUSTOMER_PRACTICE_NAME]))) ,
ISINSCOPE('Rank Analysis'[Entity]) ,CALCULATE (
[% of Total(GP)],
FILTER (all('Rank Analysis'),'Rank Analysis'[Entity] <= MAX ('Rank Analysis'[Entity]))) ,
CALCULATE (
[% of Total(GP)],
FILTER ( ALL ('Rank Analysis'), 'Rank Analysis'[F_LEVEL4_DESC] <= MAX ('Rank Analysis'[F_LEVEL4_DESC])))
)
Hello @amitchandak ,
Tried the measure you have shared still it is not working and giving the same error as above.
Is there any other way we can optimize the DAX?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |