Forum Discussion
Measure problem with USERELATIONSHIP
Hi! This is my Power BI Model, a simplify version: I have a selector based on PERCENTAGE TABLE[PERCENTAGE] which objective is to filter on the % FILTERED measure defined as % FIL...
You can try modifying the % FILTERED measure to ensure that the filter context is correctly applied. Here is a revised version of your measure:
DAX
% FILTERED =
IF(
ISFILTERED('PRODUCT'[PART]) || ISFILTERED('PART'[PART]),
CALCULATE(
[%_PART],
USERELATIONSHIP('PERCENTAGE TABLE'[PERCENTAGE], 'PRODUCT'[PART_PERCENTAGE])
),
CALCULATE(
Doesn´t work, sorry.