Forum Discussion
Add filter value into the report header
- 10 years ago
mroomi, Example below
Measure Defined a below:
Filtered Year = IF ( ISFILTERED(vw_Name[PSPStatus]), CONCATENATE("Document Count for the Fiscal Year ", (IF(HASONEVALUE(vw_Name[PSPStatus]), FIRSTNONBLANK(vw_Name[PSPStatus],"") ,""))), "Report Page is not Filtered by FY")
Table Data:
Table DataNo Values in Filter
Noticed that Long Text Visual is unable to take Measure as an input ...
Hope this helps!
mroomi, Example below
Measure Defined a below:
Filtered Year = IF ( ISFILTERED(vw_Name[PSPStatus]), CONCATENATE("Document Count for the Fiscal Year ", (IF(HASONEVALUE(vw_Name[PSPStatus]), FIRSTNONBLANK(vw_Name[PSPStatus],"") ,""))), "Report Page is not Filtered by FY")
Table Data:
Table DataNo Values in Filter
Noticed that Long Text Visual is unable to take Measure as an input ...
Hope this helps!
It, worked perfectly, really appreciate all of you guys help.