cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
marci723 Frequent Visitor
Frequent Visitor

Measure from SSAS multi-dimensional cube seems to be displayed incorrectly

Hi Folks!

 

I'm struggling with the following issue:

- I've got a multi-dimensional cube deployed like this one

cube.png

- My measure was supposed to be first, "vendegszam" column, but later I figured it will be better to distinct count the second, "vendeg_id" column in the Fact table

- I've got 104 lines in the fact table, but since I did the distinct count on the mentioned column, I could manage to get the proper, 25 as result in excel after I connected to the cube.

 

Funny thing is when I tried the same, connected to the cube, but this time through Power BI, my measure showed 104.

 

My questions is, how is this possible and how can I fix it in Power BI?

 

Many thanks,

Marci

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Measure from SSAS multi-dimensional cube seems to be displayed incorrectly

Hi @marci723

Try this formula

Measure=CALCULATE(DISTINCTCOUNT(Table[vendeg_id]),ALL(Table))

 

Best Regards

Maggie

2 REPLIES 2
Community Support Team
Community Support Team

Re: Measure from SSAS multi-dimensional cube seems to be displayed incorrectly

Hi @marci723

Try this formula

Measure=CALCULATE(DISTINCTCOUNT(Table[vendeg_id]),ALL(Table))

 

Best Regards

Maggie

marci723 Frequent Visitor
Frequent Visitor

Re: Measure from SSAS multi-dimensional cube seems to be displayed incorrectly

Thanks Maggie, that worked when I used the Import method. However I figured that the difference between excel and PBI is because of the data connection (live vs import) method. It also works fine if I choose Live connection.

 

Thanks again!

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 203 members 2,732 guests
Please welcome our newest community members: