Forum Discussion
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