Dimensionality (QlikView) in PowerBI

[giuliapiazza94]

Hi guys,

I've to convert a QlikView report in a PBI report. 

In a table there is a measure like "if ( dimensionality = 0,  A, B).

I think I understand the meaning but I don't know which function can I use.

Can you help me?

Thank you 🙂

[giuliapiazza94 · Accepted solution]

I've solved the problem of DIMENSIONALITY (QlikView) using the function ISINSCOPE that allows me to manipulate the dimension of the matrix

[v-yanjiang-msft]

Hi @giuliapiazza94 ,

According to your description, you can use MAX function, it will return the value of current row. You can use it like this:

Or you are still confused about it, please provide me with more details about your issue.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@giuliapiazza94 

Hello,

you can use if in Power BI in measure or column.

But what I think here is happening that the dimensionality is Qlik Variable and in this case condition is that if dimensionality= False.

[Greg_Deckler]

@giuliapiazza94 What is dinensionality? If it is a measure or column you could do IF([dimensionality]=0,"A","B")

[giuliapiazza94]

A column. 

For example 

dimensionality (A and B and C) = 2

dimensionality (D) = 1

the 3 rows has dimensionality = 0

It should be correct

I can't use IF (column) but I can only do IF (measure)