Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
88 | |
72 | |
68 | |
64 | |
54 |
User | Count |
---|---|
98 | |
91 | |
74 | |
68 | |
63 |