3 Replies Latest reply on Jan 21, 2018 3:03 PM by Chris Marfisi

    Tableau warnings on Micrsoft SSAS tabular cubes

    Peter Larsen



      We are currently implementing a SSAS tabular cube as the data source for at Tableau report. We are however experiencing that tableau is displaying warnings and showing dimensions in grey which is not expected.



      A simple data model could be:





      In Fact_Sales i have created the following measure showing the total sum for all "toy cars" sold.


      Sum of Amount:= CALCULATE(SUM(Amount);FILTER(Dim_Category;Dim_Category[Name] = "toy cars"))


      - Why does Tableau give the following warning on measures when dimensions are used as filters : "WARNING: This measure is incompatible with one or more of the dimensions in the view"?



      - Why does Tableau grey out all dimensions when a measure is added to the view?