How to display the data with specific period as default to the dashbord

[474Raghad]

Hi Team, 

I'm using a specific measure that is return True/Fasle. I want the dashboard to present the data that is related to the True values how to set this setting without using the filter in the dashboard because I'm using a sliver to filter the period and whenever the user choose a specific year the dashboard will be filtered in the chosen year ? 

[raju8004212]

Hi @474Raghad 

please follow below steps it will help you solve.

If you want all visuals on a page/report to be restricted to TRUE rows (like RLS, but not user-based), you can create a calculated table that contains only the TRUE rows:

FilteredData =
FILTER ( OriginalTable, [MyCondition] = TRUE )

Then build your visuals on top of FilteredData instead of the raw table.

[anilelmastasi]

Hello @474Raghad ,

If you're writing a measure like:

TotalSales = SUM(FactSales[Amount])

You can wrap the measure in a filter that returns only rows where your Boolean condition is true.

 Assume you have a measure:

[IsQualifiedCustomer] =
Some condition returning TRUE or FALSE

Then use:

TotalSales_OnlyQualified =
CALCULATE(
SUM(FactSales[Amount]),
FILTER(
ALL(FactSales),
[IsQualifiedCustomer] = TRUE()
)
)

This ensures that only rows where [IsQualifiedCustomer] is TRUE() are included in the calculation, regardless of visible filters. And it respects slicers like Year or Period — because those apply outside the CALCULATE context unless removed with REMOVEFILTERS() or ALL()

If this solved your issue, please mark it as the accepted solution. ✅