Get Varience on Matrix

[Anonymous]

Hi,

The below code does not seem to work, I can bring in the matrix details fine, but when I am trying to say give me last years value (Same PeriodLastyear) based on the filter it does not work.

Any ideas...

Thanks

C

=CALCULATE (    DISTINCTCOUNT ( AdDetails[company] ),    CALCULATETABLE (        SUMMARIZE ( AdDetails, Table2[Company Grouping]),        ALL ( titles ),        USERELATIONSHIP ( AdDetails[ttlname],'FilterTitle'[filterttlname] ),SAMEPERIODLASTYEAR('Calendar'[Date])
    )

[v-haibl-msft]

@Anonymous

Could you please give some sample data, relationships of your tables and the expected output?

Best Regards,

Herbert

[Anonymous]

Its ok Herbet,

I spoke to someone from PowerBi who says you cant have indirect relationship between tables, so not sure how it can be done in PowerBI

[v-haibl-msft]

@Anonymous

For relationships in Power BI, please refer to this document.

To see if we can get your expect result, we need the sample data of your tables.

Best Regards,

Herbert

[Anonymous]

Hi Herbert,

It seems you cannot not have inactive relationships in PowerBi, someone will hopefully come up with a grpahic in R or something.

Thanks

Chris

[v-haibl-msft · Accepted solution]

@Anonymous

We can mark relationships as inactive to reduce ambiguity in Power BI as below.

Best Regards,

Herbert

[Anonymous]

Thanks will have a look into that!

[Anonymous]

I am trying to get it to look like

http://blog.gbrueckl.at/2014/02/applied-basket-analysis-in-power-pivot-using-dax/

I have it working in excel now trying to convert it to PowerBI.

Thanks