Erroneous Results from COUNTROWS() in Context-transition
Unless I'm missing something, I'm pretty sure this isn't supposed to happen: EVALUATE CALCULATETABLE ( CALCULATETABLE ( ADDCOLUMNS ( VALUES ( Users[User ID] ), "Test Expression 1 - CORRECT", CALCULATE ( CONCATENATEX ( FILTER ( VALUES ( 'Privilege Conflicts'[Privilege 2 ID] ), 'Privilege Conflicts'[Privilege 2 ID] IN VALUES ( Privileges[Privilege ID] ) ), 'Privilege Conflicts'[Privilege 2 ID], " | " ) ), "Test Expression 2 - INCORRECT", CALCULATE ( COUNTROWS ( FILTER ( VALUES ( 'Privilege Conflicts'[Privilege 2 ID] ), 'Privilege Conflicts'[Privilege 2 ID] IN VALUES ( Privileges[Privilege ID] ) ) ) ) ), CROSSFILTER ( 'Users and Privileges'[Privilege ID], Privileges[Privilege ID], BOTH ) ), Users[User ID] IN { 102, 103 } ) Results: Notice how, for User ID = 102, the results in the test expressions are inconsistent, despite the fact that they are semantically basically the same. For reference, note that the following produces expected results: EVALUATE CALCULATETABLE( CALCULATETABLE( { ( -- Test Expression 1 - CORRECT CALCULATE( CONCATENATEX( FILTER( VALUES( 'Privilege Conflicts'[Privilege 2 ID] ), 'Privilege Conflicts'[Privilege 2 ID] IN VALUES( Privileges[Privilege ID] ) ), 'Privilege Conflicts'[Privilege 2 ID], " | " ), Users[User ID] = 102 ), -- Test Expression 2 - CORRECT (inconsistent with prior query) CALCULATE( COUNTROWS( FILTER( VALUES( 'Privilege Conflicts'[Privilege 2 ID] ), 'Privilege Conflicts'[Privilege 2 ID] IN VALUES( Privileges[Privilege ID] ) ) ), Users[User ID] = 102 ) ) }, CROSSFILTER ( 'Users and Privileges'[Privilege ID], Privileges[Privilege ID], BOTH ) ), Users[User ID] IN { 102, 103 } ) Results: --- It appears that something might not be functioning correctly between the context-transition and COUNTROWS(), but not fully sure. marcorusso Jeffreywang --- Power BI version: 2.139.2054.0 Data model:
Cannot load model
Hi, When I open my .pbix file in Power BI Desktop app, I immediately get this message: Interestingly, the associated PowerBI report in the workspace seems to be refreshing from the model (and linked datasources) regularly. I need to make changes to the model however, and I can't do so in PowerBI Desktop, because of the 'Cannot load model' window. None of the visualisations appear in the Desktop app when i close the error message. I have found this page that refers to 'Analysis Services' also, but I don't know whether this is the right place to go to to try and rectify and overcome the issue. Any help would be much appreciated.
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!
TMSL Alter Column Description
I am a noob in TMSL and I need your help. I am trying to add a description to the column in Power BI Services with a command: { "alter ": { "object": { "database": "dataset_test", "table": "005_SHIP_TO_LOCATIONS", "column":"CREATION_DATE" }, "column": { "name": "CREATION_DATE", "description":"This is the new description" } } } The error I get is: Unrecognized command: alter . Check path '['alter ']', line 2, position 13. Could you help me to make it work? This is Power BI Premium and I TMSL works for table name modification, but I can't figure out how to change the column description.
