User Profile
adam12237
Advocate I
Joined 6 years ago
User Widgets
Contributions
Creating a Slicer based on Range of Measure values - SSAS
Hi! I have created a Measure called [OverallBlendedScore]: (( [AveragePatientDTPScoreRank] * SELECTEDVALUE ( 'SliderDTP'[DTPWeight] ) ) + ( [AveragePatientCoreConditionCountRank] * SELECTEDVALUE ( 'SliderMedCondition'[MedConditionWeight] ) ) + ( [AverageSVIOverall] * SELECTEDVALUE ( 'SliderSVI'[SVIWeight] ) ) + ( [AveragePatientDrugCountRank] * SELECTEDVALUE ( 'SliderDrugCount'[DrugCountWeight] ) )) / [TotalSelectedWeights] I want to know how to create the range of values in [OverallBlendedScore] as a Slicer. The range of expected values is 0-100. I am using Analysis Services tabular model and Tabular Editor. I feel like I should create a new calculated table that provides the values, but not too sure. Any help is appreciated!Re: Need help in creating a filter (number range) that would count medical conditions as a function
here is some deidentified data: Essentially, it is a new calculated column, performing a countrows fx, for each patient in evaluation. For example, the new column would count 6 conditions for the first patient, and list 6 for row...Need help in creating a filter (number range) that would count medical conditions as a function
Hi! I have a mini-tabular model based around medical conditions, which is supporting an interactive dashboard: I was wondering if there was a way to create an on screen number range filter (similar to 'ConditionCount' above) that would 'react' to the number of [Conditions] selected: For example, if I selected Asthma, BPH, Cancer, and CHF, the range would be between 1-4, essentially tallying count/sum of conditions for a patient as a function of a fluid array of conditions. Thanks for any help!Allow Export Data with Visual Header Off
Anybody besides myself wanting to publish a rich dashboard (which contains drill through detail tables from graphs) and turning off every visual header (so that clients cannot see which filters are affecting the visuals/page/all) just to find out that by disabling the visual header, you are not able to export the data? And even when you are able to export the data, the first row in the export contains all the unwanted aforementioned filters?
