The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
hi guys,
i have this table:
i need to exclude division "otros negocios" from the table but include the value of this in the measure "varmg1803" but i cant filter this with filter dax and the filter panel exclude the division and the value :S
varmg1803 measure:
Solved! Go to Solution.
Try this:
NewMeasure =
VAR Selected = SELECTEDVALUE ( 'Maestro dpto'[División] )
RETURN
IF ( Selected <> "OTROS NEGOCIOS"; [varmg1803] )
Try this:
NewMeasure =
VAR Selected = SELECTEDVALUE ( 'Maestro dpto'[División] )
RETURN
IF ( Selected <> "OTROS NEGOCIOS"; [varmg1803] )
hey
try to create a calculated column like this : ( as u see there is a blank for excluded value but its numeric value is still in a table)
I would use the Filter pane to filter your Otros value and then in the measure, just use ALL to wipe that filter away.
hi greg ty for your answer but not work :S. use what you told me in the measure but I lost the values of the divisions and the filter panel keeps modifying the value if I exclude the division
User | Count |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
30 | |
15 | |
12 | |
12 | |
7 |