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.
Hello,
inside SUMX i'm iterating over a FACTUAL, doing something like (x/a)*(a'-a), where a' is DIMENSION(SOMEVALUE2) under a different context CODE_MOMENT_T_1 (all the other "code" runs under CODE_MOMENT).
So i think that line could also be something like
CALCULATE(RELATED(DIMENSION[SOMEVALUE2]); FACTUAL[CODEMOMENT] = CODEMOMENT_T)
but the moment i do this, RELATED(DIMENSION[SOMEVALUE2]) gets underlined and i got an error message saying "Parameter is not the correct type. Cannot find name [SOMEVALUE2]"
RESULT = VAR SELECTED_2_MOMENTS = ALLSELECTED(FACTUAL[CODEMOMENT]) VAR CODEMOMENT_T = CALCULATE(MAX(FACTUAL[CODEMOMENT]); FACTUAL[CODEMOMENT] IN SELECTED_2_MOMENTS) VAR CODEMOMENT_T_1 = CALCULATE(MIN(FACTUAL[CODEMOMENT]); FACTUAL[CODEMOMENT] IN SELECTED_2_MOMENTS) RETURN IF (CODEMOMENT_T <> SELECTEDVALUE(FACTUAL(CODEMOMENT); CALCULATE ( SUMX( FACTUAL; DIVIDE(FACTUAL[SOMEVALUE]; RELATED(DIMENSION[SOMEVALUE2])) * -- calculation problem next line (CALCULATE(MAX(DIMENSION[SOMEVALUE2]); FACTUAL[CODEMOMENT] = CODEMOMENT_T; CROSSFILTER(FACTUAL[ID_CONCATENATED_ENTRY]; DIMENSION[ID_CONCATENATED_ENTRY]; OneWay)) - RELATED(DIMENSION[SOMEVALUE2])) ; FACTUAL[CODEMOMENT] = CODEMOMENT_T_1) )
Can someone help me out?
@Ricardo77 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hello @amitchandak , thanks for your help & time,
to be sincere, i already posted the question with more detail , under this link
https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-get-the-value-from-the-same-table-but-...
If you could help i would be very thankful (Y)
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 |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |