Create a dax formula to show selected quarter after removing all filters from date table

[Anonymous]

Hi All,

i am new to powerbi. i am strugling to build a dax expression that will show Selected quarter value . but before that i want to clear all filers applied on date table. could you please help me. thanks.

Arnab

[Anonymous · Accepted solution]

Hi All, thanks for helping me to crack this logic. i might not be able to clarify my challenge. Anyway i tried this logic

TT Quarter = CALCULATE( SELECTEDVALUE(Fact_Energy[YearQuarter]),CROSSFILTER ( 'Date'[Date], Fact_Energy[Full Date], NONE ))  and It Worked😀. basically i diasbled the relationship bitween fact and dim table.

[Anonymous]

Hi @Samarth_18 , please take a look at these pictures. i took slicer for Quarter (field taken from Dim_calendar) and and line chart(both sales & quarter fields taken from fact_sales table). here based on a selected quarter year from slicer i will get sales for last 3 quarters. Now i created a tooltip that will show quarter year when i hover on the line chart. but i can only see the quarter year on tooltip which is selected on the slicer, other quarter years are showing blank .

is there any way to create a dax expression that will remove any slicer selection , allow me to see all quarter year when i hover on the chart? 

[Whitewater100]

Hi:

All your date fields should come from your Calendar Table, even the sales quarter should just be quarter. The Calendar table should be marked as Date Table too and have one to many relationship with your fact table.  I'm not sure what the rest of your question is, can you rephrase it?

[Samarth_18]

Hi @Anonymous ,

Could you please share the sample data in text format with the expected output.

Thanks,

Samarth