DAX measure for report tooltip
Hi, I am new to power BI and facing issues with a conditional tooltip. I have a combined table with all the data I need. (see sample data bellow). And I created a report gruoping the products by code and displaying the min, max and average unit price I want to be able to see the technical specification (could be one value or many) when I hover over the min or max values. I have been testing few dax code to create a measure and use in the tooltip, but I couldn't get it to work. Note that one code can have multiple technical specifications and unit costs, the logic I am using is e a condition combining the code and unit price to display the coresponding technical specifications. bellow is my latest attempt, that generates an error code (MdxScript(Model) (4, 1) Tooltip = VAR SelectedID = SELECTEDVALUE('Combined table'[code]) VAR SelectedValue = SELECTEDVALUE('Combined table'[Eur/Unit]) VAR Resulttable= CALCULATETABLE( 'Combined table', 'Combined table'[code] = SelectedID && 'Combined table'[Eur/Unit] = SelectedValue ) RETURN VALUES('Combined table'[Technical specification]) Thank you in advance Simo
extracting dynamic quaterly
hi Expert i am trying to extract the quraterly and fiscal data but my qtrly and fiscal data are showing as same dax for qtrly: Current Quarter Closed PIR Fraud Exposure = Var _gsi= CALCULATE([PIR EXPOSURE],'PIR-Case-POV'[Stage] ="Closed - No Further Action Required") VAR _maxyear=MAX('Date'[Fiscal Year]) VAR _maxdate=MAX('PIR-Case-POV'[PIRReferralDate]) VAR _mxqtr=ROUNDUP(MONTH(_maxdate)/3,0) RETURN CALCULATE(_gsi,'Date'[Fiscal Year]=_maxyear,'Date'[Fiscal Quarter]=_mxqtr) in this code i am getting the fiscal year data instead of qtrly data. Is there any way to have this qtr dynamic like lets say if we want to have the previous qtr data. thank you again in advance
