Forum Discussion

bullab's avatar
bullab
New Member
3 years ago
Solved

Creating different count on same report

So I have a report based on an SQL query that gives me all Fire Hydrants with the most recent inspection date.  I need to show three counts:    1.  for the total # of hyrants (I just created a new ...
Tips and Tricks
  • bullab's avatar
    bullab
    3 years ago

    Hi.  I do want the date slicer, but I only want it to apply to certain visuals.  It seems like using the "Edit Interactions" whle have the date slicer selected, will let me decide which visuals I want it to apply too.

     

    Now I just have to figure out how to subtract one card from another and display that.  🙂

     

     

guibenassi's avatar
guibenassi
Icon for Advocate II rankAdvocate II
3 years ago

Hello bullab 
If you don´t want the date slicer change a measure, you can change use:
=CALCULATE( [MEASURE THAT COUNT HYDRANTS], ALL(DATE)
In this way you ignore any date filter context in the visual.
You can do this for all the measures that you don´t want to be filtered in any context.