Forum Discussion
Solved
How to include specific table dimension value using calculate formula (ignore slicer)?
Hi, I was wondering if this is possible. I have a table that shows Product Group, Sales and Closed Year. I have a Closed Date Slicer to the report. I would like the Closed ...
Hi ap,
Please check out the demo in the attachment. No relationship can be established.
Measure = IF ( MIN ( 'Table1'[Product Group] ) = "C", 9999, IF ( MIN ( Table1[Closed Year] ) = SELECTEDVALUE ( Table2[Closed Date Slicer] ), 2, BLANK () ) )Best Regards,
Dale
Hi ap,
Please check out the demo in the attachment. No relationship can be established.
Measure =
IF (
MIN ( 'Table1'[Product Group] ) = "C",
9999,
IF (
MIN ( Table1[Closed Year] ) = SELECTEDVALUE ( Table2[Closed Date Slicer] ),
2,
BLANK ()
)
)
Best Regards,
Dale