The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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]))))
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |