Issue with fromDate to ToDate

[Anonymous]

Hi All,

I have a scenarior to filter out date range from two columns

FromDate, ToDate

for that, I have created one Measure

Measure =

IF (

SELECTEDVALUE ( 'Table'[SrFromDate] ) <= MAX ( DimDate[FullDateAlternateKey] )

&& SELECTEDVALUE ( 'Table'[SrToDate] ) >= MIN ( DimDate[FullDateAlternateKey] ),

1,0

)

and used this measure in visual level filters and set to 1.

Its working fine If i have multiple columns available in grid.

But it does not work fine if i just want to see count of particular row in any other seprate grid.

Any idea how to fix this?

[Anonymous]

usually when you select a slicer, the selcted value becomes in the range of the selected range of date,
so try remove filters with the dax calculation to something like

measure = IF (
SELECTEDVALUE ( 'Table'[SrFromDate] ) <= calculate(MAX ( DimDate[FullDateAlternateKey] ),removefilters(dimdate[date]))
&& SELECTEDVALUE ( 'Table'[SrToDate] ) >= CALCULATE(MIN ( DimDate[FullDateAlternateKey] ),removefilters(dimdate[date])),
1,0
)

[Anonymous]

Hi @Anonymous 

You can refer to this blog .

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous 

Can you explain "But it does not work fine if i just want to see count of particular row in any other seprate grid." through a sample ? Or you can provide a pbix file to explain your need and expected result .

Best Regards,
Community Support Team _ Ailsa Tao

[Anonymous]

How to attache PBix file here? not able to see any option,

[Anonymous]

either import your pbix to one drive or google cloud then click on share and post the link