Adding a if(sum(XX) >Y;a;b) - Measure creates all combinations in a table

erhardrainer — Wed, 14 Aug 2019 07:47:16 GMT

Hello Experts,

I would need your help/explenation:

I have a Dimension and an Fact_Table.

Fact_Table (https://pasteboard.co/IsyQ88z.png)

Dim_Table (https://pasteboard.co/IsyQWxM.png)

They are connected by Type (https://pasteboard.co/IsyRpcL.png)

When I create a Measure (eg: Measure = if(sum(Table1[Value])=2;"green";"red")) the table has all combinations of of Type. (https://pasteboard.co/IsyT9pH.png)

What's wrong with the measure and why?

Thanks in Advanced.

BR Erhard

Change datasource from sql to tabular model

erhardrainer — Thu, 27 Apr 2017 23:43:24 GMT

Hi Experts!

We have a lot of dashboards designed for Power BI in the Cloud and started migrating them to SQL vNext Power Bi on prem.

We achieved to convert the Power BI Model to a Tabular Models and now I want to change the data source from SQL to the converted Tabular Model. In the Datasource Settings it is only possible to change the connection from from SQL-Server to an other. Is there a possibility to change from SQL-Datasource to Tabular Model?

Thanks in advanced.

erhardrainer Tracker

Adding a if(sum(XX) >Y;a;b) - Measure creates all combinations in a table

Change datasource from sql to tabular model