Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Folks!
I'm struggling with the following issue:
- I've got a multi-dimensional cube deployed like this one
- 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
Solved! Go to Solution.
Hi @marci723
Try this formula
Measure=CALCULATE(DISTINCTCOUNT(Table[vendeg_id]),ALL(Table))
Best Regards
Maggie
Hi @marci723
Try this formula
Measure=CALCULATE(DISTINCTCOUNT(Table[vendeg_id]),ALL(Table))
Best Regards
Maggie
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |