Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to create a measure which will react to the selected values on a filter
I have created this: Selected values = CALCULATE(SUM(USECASE_ADM_DETAIL[LOTS]),FILTER(USECASE_ADM_DETAIL,(USECASE_ADM_DETAIL[LEGALENTITYID] = SELECTEDVALUE(USECASE_ADM_DETAIL[LEGALENTITYID]))))
However when I select multiple values from the LEGALENTITYID field, the measure no longer works.
Any help would be great
Solved! Go to Solution.
CALCULATE(SUM(USECASE_ADM_DETAIL[LOTS]),FILTER(USECASE_ADM_DETAIL,(USECASE_ADM_DETAIL[LEGALENTITYID] in values(USECASE_ADM_DETAIL[LEGALENTITYID]))))
CALCULATE(SUM(USECASE_ADM_DETAIL[LOTS]),FILTER(USECASE_ADM_DETAIL,(USECASE_ADM_DETAIL[LEGALENTITYID] in values(USECASE_ADM_DETAIL[LEGALENTITYID]))))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
37 | |
21 | |
19 | |
15 |
User | Count |
---|---|
125 | |
34 | |
27 | |
25 | |
24 |