Store a parameter in DAX and use it

[lassuied]

Hello Everyone,

I created a table called "Parameters" and a measure in this table called "YearReport".

In DAX I have done a simple formula where : YearReport = 2017

Now I would like to use this to filter my other DAX but Power BI doesn't let me use the filter ... the thing is if I type 2017 in the filter it is working, but not the DAX, here is an example :

CountofContractsCY = calculate(COUNTA(v_e2AllColumns[ContractDetail_NumberUnderContract]),'1_PrincipaleTable2'[Scenarios]=[YearReport],v_e2AllColumns[LotDemographics_IsPhysicalLocationFlag]=True)

Is there anything else I can do to keep that dynamicity ?

Thank you !

[Greg_Deckler · Accepted solution]

See reply in duplicate thread.

[Anonymous]

Hi Greg, 

Please share the duplicate thread. We are also looking for a solution like the same .