Forum Discussion
Solved
0 values
Hi, I have a data set which includes answered and unanswered call details. If i select one user name it will show "0' because that user didnt answer any calls. So, I want to show a card showi...
Hi,
This is the sample data set. If I select user name as "C" in my filter slicer then i want to show a card that showing "he is not answered any calls"
Measure for your card:
Measure =
VAR NumCalls =
SUM ( Table1[Answered Calls] )
RETURN
IF ( NumCalls = 0; "hasn't answered any calls"; NumCalls )Thank You so much
Hi AlB
I want to know the following thing as well.
After I upload the below excel sheet into power bi it will show an error in the highlighted row.
How can i change the data type in Power BI as dd:hh:mm:ss?( days, hours, minitues and seconds)