I think i need to use DAX

Anonymous — Sat, 18 Jan 2020 04:09:50 GMT

How would I filter one table for the queries below? I have the sql queries which will give me the data but, I have no idea on how to do this in power bi. For example 1. I need to show a visual of the % of valid e-mails converted to case (higher is better). That means I need to get the value of (Valid e-mails converted to case) / (Total valid e-mails). Below that is a query but, I don't know how to do this. Resolution_SubType is a colum and Action Required Reason too.

% of valid e-mails converted to case (higher is better)
1. (Valid e-mails converted to case) / (Total valid e-mails)

[( (Resolution_SubType != SPAM && Action Required Reason !="Manually fixed to not spam") /(( Resolution_SubType != SPAM && Action Required Reason =="Manually fixed to not spam"))]

Valid e-mail converted to case: E-mail auto-converted to case. Case closed as Resolved

[(Resolution_SubType != SPAM && Action Required Reason !="Manually fixed to not spam") ]

Total valid e-mails: (1b) + # E-mails manually converted to case

[( (Resolution_SubType != SPAM && Action Required Reason !="Manually fixed to not spam") + (Resolution_SubType != SPAM && Action Required Reason =="Manually fixed to not spam")]

Re: I think i need to use DAX

Stachu — Wed, 22 Jan 2020 08:23:21 GMT

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1	Column2
A	1
B	2.5

topic Re: I think i need to use DAX in DAX Commands and Tips

I think i need to use DAX

Re: I think i need to use DAX