Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I got the following issue. I have to show a table with the values per year and I also have to show the sum of them.
In order to consider a currency translation I am using the following measure to show the data:
I would really appreciate your help....!!!!
Solved! Go to Solution.
Hi @Anonymous, Try this.
Hi @Anonymous ,
Since there is no specific pbix file for you, you can refer to my similar template data below.
It showed me 2+2=3, on total,but I want to show here 4.
base data:
measure:
visit(cal) = DISTINCTCOUNT(Spending[date])
Visit = VAR _table = SUMMARIZE(Spending, Spending[member_number], "distinctcount", DISTINCTCOUNT(Spending[date]))
RETURN
SUMX(_table, [visit(cal)])
Final I create another measure:
test = if(HASONEVALUE(Spending[branch_name]),[visit(cal)],SUMX(DISTINCT(Spending[branch_name]),[visit(cal)]))
Output:
You could adjust on my sample .And if question still not solved ,could you pls share your pbix file ,and remember to remove confidential data.
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi @Anonymous, Try this.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |