Forum Discussion
Solved
Need Help on DAX formula..
Hi I wrote the below measure in BI to have the result of the no. of reporting as shown in excel. Span = CALCULATE(COUNT(WD[Workday ID])) / CALCULATE(COUNT(WD[Is Manager]), FILTER(WD, WD[Is Manag...
Hi engyin2,
First your error, it is because that the Column Layer is a Text type column. It cannot be used to minus 1 directly. To resolve this error, you just need to change the column typle to whole number.
Then to achieve your requirement, you can try following measure:
Span = CALCULATE ( COUNT ( WD[Layer] ), FILTER ( ALL ( WD ), WD[Layer] = SELECTEDVALUE ( WD[Layer] ) + 1 ) ) / CALCULATE ( COUNT ( WD[Layer] ), FILTER ( WD, WD[Is Manager] = "Yes" ), ALLEXCEPT ( WD, WD[Layer] ) )Thanks,
Xi Jin.
Hi,
Share your source dataset and show the expected result.
Hi Ahish,
Here is the example of the source and the expected result. Thanks.
Hi,
I cannot see the column headings - what is O9? N8?