The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello All!
I have converted a blank value to NA of two of my parameter
i.e. A and B both datatype is currency if value is blank then convert it to NA using isblank dax
noew i'm trying to achive percent format of calculation
i.e. A/B
,but there is a region where both A and B values are BLANK and when indiviually represented it shows NA on card visual.
DAX :- % revenue = Divide(A,B)
and in percent format.
But I'm getting error as below screenshot,
I hope i'm able to make you understand it,
Thank is advance.
Hi,
the problem is that you have text values ("NA") in your columns. PowerBI can't perform a division on text values, which is why it's throwing this error message.
User | Count |
---|---|
77 | |
75 | |
36 | |
31 | |
29 |
User | Count |
---|---|
94 | |
80 | |
55 | |
48 | |
48 |