Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

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 ? 

Dashboard
dates
default

2 Replies

  • anilelmastasi's avatar
    anilelmastasi
    Icon for Super User rankSuper User
    1 year ago

    Hello Anonymous ,

     

    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. ✅
  • raju8004212's avatar
    raju8004212
    Frequent Visitor
    1 year ago

    Hi Anonymous 

    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.