slicing measure problem: Measure is not getting sliced.

[Anonymous]

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

[dkay84_PowerBI]

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

[Anonymous]

Good idea about % of grand total - I will give it a go. But are there options alter decimal places?

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

We can change the Decimal Places like below:

Best Regards,
Qiuyun Yu