Forum Discussion

yukim92's avatar
yukim92
New Member
4 years ago
Solved

measure questions

Hi guys i have 2 questions:

 

1. If I have the same input data table but this time have multiple days columns (shown in "New Scenario" report tab in file) how can I alter the Count of Days measure along with % Culm Count of Days without creating multiple separate measures for each days column? Not sure if what I am suggesting is the right way or if it is indeed better to have a separate measure which counts each of the separate days columns & performs the cumulative % on each separately.

 

2. The current measures (due to the ALLSELECTED function) should work in the real case where I have slicers to filter the data (which come from separate tables but linked via ID) right? As in if I have a date, and provider slicer and I select a range and a particular provider the summary should automatically change to reflect the slicers selection providing the data model itself (relationships etc) are configured?

File: https://dl.dropboxusercontent.com/s/7a232asddaj9v/data.txt

  • yukim92 1) You either need separate measure, create new measures, or shadow an existing measure for debugging without the apply to model/write step
    2: Yes ALLSELECTED will reflect your filters affecting your visual

1 Reply

  • RayWu's avatar
    RayWu
    Icon for Memorable Member rankMemorable Member

    yukim92 1) You either need separate measure, create new measures, or shadow an existing measure for debugging without the apply to model/write step
    2: Yes ALLSELECTED will reflect your filters affecting your visual