Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table with 4 distinct names per month.
i want to only consider the names begins with 22, and the only acumulated positive values per month and name.
Above i report the expected result.
Hi @ruinaldo ,
Sorry to disturb you again...
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Eyelyn Qin
i try this formula and result the filter for the name 22.
In visual for the month january it´s all ok, i only have positive values in "22-green" and is 10
but how can i do it for a card? i don´t want 4 in result but 10
Hi @ruinaldo ,
You could use the following formula to create new measure for Card visual:
Measure2 = MAXX(FILTER(ALL('Table'),'Table'[Name]="22-green"),[Measure])
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
@ruinaldo , Try a measure like
calculate(sum(Table[Value]),filter(Table, left(Table[name],2)= "22" && Table[Value]>0))
Hi,
Thanks for your help. But didn´t work,
The result is:
i expected in april 22green= 10 and 22red = 1
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |