DAX help

Anonymous — Fri, 08 Mar 2019 06:41:19 GMT

Hi All,

I am facing difficulty in creating a dashboard. Can anyone help me? Sample File here->https://github.com/ssijbabu/PowerBI

Please find the sample data below.

Application	Division	Month	Request	Incident
App1	Div1	12/01/2018	5	3
App2	Div1	12/01/2018	3	7
App3	Div2	12/01/2018	8	2
App1	Div1	01/01/2019	3	7
App2	Div1	01/01/2019	5	2
App3	Div2	01/01/2019	8	9
App1	Div1	02/01/2019	2	3
App2	Div1	02/01/2019	8	5
App3	Div2	02/01/2019	5	2
App1	Div1	03/01/2019	2	8
App2	Div1	03/01/2019	8	4
App3	Div2	03/01/2019	3	9
App1	Div1	04/01/2019	9	6
App2	Div1	04/01/2019	3	7
App3	Div2	04/01/2019	6	3

I am trying to create the following measures
1) Total Tickets - Request + Incident -> Created while loading the Data
2) Last 3 months Total Tickets Avg -> this should be dynamic based on user month selection
3) App Classification -> Calculated based on 3 months avg, if the number fall between 0-5 -Small, 6-10 -Medium, 10-20 -Large.
4) App Cost -> Same as Application classification, if the number fall between 0-5 - $1000, 6-10 -$5000, >10 -$20000.

I am facing problem with 3rd and 4th measure.
I created measure using SWITCH statement, i am getting wrong number in total.
For 3rd measure, no total should be dispalyed. For 4th measure, its not calculating the sum of rows,
So i tried to implement the same in calculated column, but receiving circular dependency error.

Can some one help me how to implement it.

Regards

Sujay

Re: DAX help

sanimesa — Fri, 08 Mar 2019 20:41:41 GMT

You could turn off the totals from the table visual and use cards to display the summary information.

Re: DAX help

sanimesa — Fri, 08 Mar 2019 21:08:43 GMT

I found a good thread which addresses the exact problem:

https://community.powerbi.com/t5/Desktop/Incorrect-Measure-Total/m-p/454679#M210659

BTW this post probably belongs in the Desktop forum, this forum appears to be for extensions.

topic DAX help in Developer

DAX help

Re: DAX help

Re: DAX help