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 there
I thought i used to be awesome with Dax but I couldnt figure out the simplest question!
Basically I got a Time dimension below and the Skype measure which is a measure from a Fact skype table. Its a simple coutrows measure so its Skype Logon Sessions = countrows(skype)
The 2 tables go one-to many relationship Time -> SkypeTime
Its great, the number updates when applying slicers. My next task is to calculate the current row against total.
For example 00:00:00 I want to dax it so that its 1823/911487. I dont know how to achieve this cos the grand total and row total is derived from a measure.
Please can you help?
My second question is, my alternative was I created a calculated Column in the above table, a simple column = [Skype sessions]
The number populate OK but if I apply a slicer that comes from another table which has a direct relationship to Skype table but not to Time table - the column isnt update!
So i amend dax to be = calculate([skype sessions], allexcept(table1, table1[slicer1])) that didnt work either 😞
So 2 questions please can someone help?
Thank you
Solved! Go to Solution.
Hi @Anonymous,
We can change the Decimal Places like below:
Best Regards,
Qiuyun Yu
Would adding the [Skype Logon Sessions] a second time and changing the Quick Calc to % of Grand Total do the trick?
For the slicer aspect, you will need to provide more detail about the relationship with the slicer's table and maybe provide some sample data
Good idea about % of grand total - I will give it a go. But are there options alter decimal places?
Hi @Anonymous,
We can change the Decimal Places like below:
Best Regards,
Qiuyun Yu
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |