Sum only Values where another Column has Data
Harder than it looks: I have this simple table like below: I want to calculate how we're performing based on the goal in a Card. So I need to Sum only the goal values where the Gross Adds column is not blank(GAs are in the past and Goals are for the whole month). In theory this should work, but it puts a total for all the months previous rather than what is selected in the slicer. What's strange is if I replace [GAGoal] with [Gross Adds] in the measure below it correctly adds up the Gross Adds for the current month selected in the slicer. GoalTotalCurrent = VAR LastDaySelection = LASTNONBLANK ( 'Calendar'[Calendar Date], [Gross Adds] ) VAR CurrentRange = DATESBETWEEN ( 'Calendar'[Calendar Date], MIN ('Calendar'[Calendar Date] ), LastDaySelection ) RETURN IF ( LastDaySelection >= MIN ( 'Calendar'[Calendar Date]),CALCULATE ( [GAGoal], CurrentRange )) I've tried things like this, but it results in blank: SumGoals = IF(SUMX('Subscriber Activity',[Gross Adds])<>Blank(),SUMX('Subscriber Activity',[GAGoal])) So it shouldn't sum 1/8,1/9,or1/10 Date Goal Gross Adds 1/1/2025 5 6 1/2/2025 7 5 1/3/2025 8 7 1/4/2025 7 7 1/5/2025 4 3 1/6/2025 3 2 1/7/2025 2 1 1/8/2025 5 1/9/2025 5 1/10/2025 5
Weather Visual
Hello all! Hope you are all well and somebody out there can help me. I am currrently building a dashboard and would like to have the weather temprature showing on the "card" visual. any ideas how to make this work? I have had a look online and cant seem to come across anything. If you have a idea or any tips please let me know. Many thanks 🙂
RANKX & CARD
Hello, I have a dataset named "CollectionData". I will introduce you the columns in the table and the first 5 rows in these columns. Date EkipName CollectionSourceGroup CollectionTRY CurrentUPB 01.06.2020 Inbound Protocol 234234 44354 10.10.2021 Outbound Diger 34324 4534 17.03.2022 Diger Execution Office 342 3454 20.05.2022 Diger Salary Attachment 345 454 Toplam Tahsilat = SUM(CollectionData[CollectionTRY]) Toplam Anapara = SUM(CollectionData[CurrentUPB]) What I want to do is I split the "Toplam Tahsilat" and "Toplam Anapara" fields into each other. I sorted them by "EkipName" and "CollectionSourceName" columns, from largest to smallest. No problems so far. I am sharing the Measure below. SIRALAMA = IF( OR( HASONEFILTER(CollectionData[EkipName]), HASONEFILTER(CollectionData[CollectionSourceGroup]) ), RANKX( ALL(CollectionData[EkipName],CollectionData[CollectionSourceGroup]), DIVIDE([Toplam Tahsilat], [Toplam Anapara], 0) ) ) It should not be forgotten that there was also a "Date" field in Raw Data, but I removed the "Date" field in the table. So I changed the Context and sorted accordingly. But what I want to do is I want to show the value of "EkipName" as "Card" of the row with the largest order. I wrote the following DAX for this, but it doesn't work. Because the Context is different. ForCard = IF ( [SIRALAMA] = 1, MAXX ( FILTER ( CollectionData , [SIRALAMA] = 1 ), CollectionData[EkipName] ) ) Can anyone help? Thanks.
Show the percentage value of a cell in a card
Hello, community. Please, I'm trying to show the % value of "RECEIVED, POSTED" status in one card. I created the card using the same columns but when I filter the status, the result show "100%" not "29.16%" This is the result of the card I created after filtered. Thanks!Percentage of dashboard Card / Silcer filter results
Hello everyone, I need your help & advice - We have created a dashboard which does include a Slicer & Cards. We are looking to add another Card which will Illustrate the percentage of Outage Count when a single Year is selected within Slicer "Year"(see snap shot below) I am not suprise the DAX script created below does not work. Any help would be greatly appreciated. Percentage Count = SUM('MajorIncidentTickets_2022-23'[number]) /CALCULATE(SUM('MajorIncidentTickets_2022-23'[number]), FILTER(ALL('MajorIncidentTickets_2022-23'),'MajorIncidentTickets_2022-23'[problem_id]=SELECTEDVALUE('MajorIncidentTickets_2022-23[problem_id]))
how to make the cartoes present correlated data without filter
I created a report with cards and a general filter, where I make the selection of customers and other parameters. However, each card in my report presents a way to present the data unrelated to each other, when the general filter is for disabled Example: The customer name card displays the customer's first name in alphabetical order. I wanted that even with the gral filter Disable the cards to be connected to each other, having correlation of the data
