The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi All,
I've below dax. Suddenly I'm getting error of "cannot convert value type text to type true/false" and tried lot of methods but its not resolving. Can anyone please guide me here. Request ID is general type rest all columns in Text. Please suggest..
Running Total =
CALCULATE(COUNT('SRQ PP'[Request ID]),
FILTER(ALLEXCEPT('SRQ PP','SRQ PP'[Client Region],'SRQ PP'[Assoc Team],'SRQ PP'[Request Type - TAT],'SRQ PP'[Final Closed Month]),
'SRQ PP'[Rank]<=MAX('SRQ PP'[Rank])))
--------------------------------
Running Total% =
DIVIDE(
CALCULATE(
COUNT('SRQ PP'[Request ID]),
FILTER(ALLEXCEPT('SRQ PP','SRQ PP'[Client Region],'SRQ PP'[Assoc Location],'SRQ PP'[Request Type - TAT],'SRQ PP'[Final Closed Month]),
'SRQ PP'[Rank] <= MAX('SRQ PP'[Rank]))),
CALCULATE(
COUNT('SRQ PP'[Request ID]),
FILTER(ALLEXCEPT('SRQ PP','SRQ PP'[Client Region],'SRQ PP'[Assoc Location],'SRQ PP'[Request Type - TAT]),'SRQ PP'[Final Closed Month])))
Solved! Go to Solution.
@PowerBIBeginer , there is not filter condition here
FILTER(ALLEXCEPT('SRQ PP','SRQ PP'[Client Region],'SRQ PP'[Assoc Location],'SRQ PP'[Request Type - TAT]),'SRQ PP'[Final Closed Month])
what filter you want on month
Hi Amit,
Thanks for reply. I didnt get but filter on month?
@PowerBIBeginer , there is not filter condition here
FILTER(ALLEXCEPT('SRQ PP','SRQ PP'[Client Region],'SRQ PP'[Assoc Location],'SRQ PP'[Request Type - TAT]),'SRQ PP'[Final Closed Month])
what filter you want on month
Hi @amitchandak ,
I am trying to calculate values in % such as every X-axis value is considered 100%, hence using filter in my DAX, but getting the error for cannot convert text type to true/false. I am using following DAX:
Hi Amit, got your point now.. in denominator there should not be filter, its entire count.. Great Thanks..!!
User | Count |
---|---|
86 | |
84 | |
36 | |
35 | |
30 |
User | Count |
---|---|
97 | |
75 | |
66 | |
55 | |
53 |