a few newbie questions

[db042190]

hi.  i'm just getting started.  will pbi be able to read two cubes at the same time for the same canvas?  Also, my new tabular model's most important measure is y / (y + n) which is called an agreement rate and is basically number of YES answers in a study divided by number YES's + number NO's.  Will pbi interface with tabular like excel does (pivot feel) and recognize that tabular already has aggregations for that measure and they arent simply summations?  Also, will pbi give me the option somewhere to expand and collapse my dims?  For instance, we report stuff like this from interviewer down to form down to study down to question.  Excel natuarally allows me to click a + or - to show as much or as little detail say for a specific interviewer etc.  I'm reading the pbi intro material and havent seen anything like that yet (i have to go back to the hierarchy section to see if i missed something).  Finally, one important behavior we like is drill thru.  In pbi willl i be able to click a statistic in a summary visualization and open a visualization on the same canvas that shows a much finer level of detail for just the population represented by the stat the user clicked? 

[db042190]

pbi seems to disagree with my model's aggregate agreement rates.  See pbi and excel below.  Excel is correct.  I believe my pbi->tabular is a beta.  Also, pbi appears to be an all or none expand collapse either up or down.  This is different in excel where the choice can be much more selective.  As for drill thru, i did see in the intro a bar on a barchart being clicked and affecting another tile.  This is kind of like drill thru.  Any thoughts?  As for the multiple cube question I meant tied to the same tile and with a relationship between two or more ssas tabular models entered into pbi.

[v-sihou-msft]

@db042190

>>will pbi be able to read two cubes at the same time for the same canvas?

If you connect live to two tabular models, it's not possible to include two tabular models in same .pbix file.

>>Will pbi interface with tabular like excel does (pivot feel) and recognize that tabular already has aggregations for that measure and they arent simply summations?

Power BI can recogize the different level in visual. I want to know how you achieve different aggregation. Did you write the measure like this? As you tested, it shows incorrect result on parent level, can you select "Show items with no data" to see if it works?

>>will pbi give me the option somewhere to expand and collapse my dims?

You can expand the hierarchy in dimensions in matrix and chart visuals.

>>drill thru

Currently, there's no drillthrough action like in Excel which can go to the table with detail information of cell value. We can only multiple visual tiles which can have interaction each other.

Regards,

[db042190]

good info thx.  No I did not code my measure like that link shows.  At the moment discussions like that are difficult for me to understand especially because they reference mdx a lot in their discussion to make their point and i dont know mdx. 

But the current dax  expression AgreementRate:=Calculate(Sum('Fact'[AnswerFlag]),'Fact'[PositiveNotOther]=1) / (Calculate(Sum('Fact'[AnswerFlag]),'Fact'[PositiveNotOther]=1) + Calculate(DistinctCount(Fact[FK_CaseId]),'Fact'[NegativeNotOther]=1)) does seem to be right at all levels in excel, all levels in tableau and all levels in pbi when the other measure is dragged over to the canvas.

The other measure is coded as AgreementRateFormatted:=FIXED('Fact'[AgreementRate],4).

[db042190]

a peer recommended formating the measure.  I did that and magically both the old and new measure now show correctly in pbi.  Why is that?

AgreementRateFormatted:=FIXED('Fact'[AgreementRate],4)

same pbi file, after adding reformatted measure

[db042190]

...when i drag the new measure off the canvas, pbi shows the incorrect values for the old measure again.