Current Quarter calculation

[Anonymous]

"Current Quarter", IF(DATEDIFF(TODAY(),[Date],QUARTER)=0,"Yes","No")

I am using this statement as a slicer in my powerbi report :

The problem when it we selecT yes it is showing correct data , when we press No , it is exculding the current quarter data :

Thr requirement when selected current Yes display only current quarter , when selected No display all quarters including current quarter .

[Greg_Deckler · Accepted solution]

@Anonymous Make your Yes/No slicer into a 2 rows in a disconnected table. Then construct a measure like:

Measure =
  VAR __Current = SELECTEDVALUE('ParameterTable'[Column])
  VAR __Value = IF(
                    __Current = "Yes",
                    SUMX(FILTER('Table',[Current Quarter] = "Yes"),[Value]
                    SUM('Table'[Value])
                )
RETURN
  __Value