Power BI Calculate

[Anonymous]

Hi,

I have a bar char in my dashboard which show a measures for %Clicked by officer name.I want that by default it should the %Clicked for the Current month but if user select a filter for Last month then it should show for that month.

I have a Datedimension table which determine if this is a "Current Month" or else it show 2020-06 etc.

Report Month = IF(MONTH(now()) = Month(DateDim[Date]) && YEAR(now()) = YEAR(DateDim[Date]), "Current Month", DateDim[Year-Month])

My

Percentage Clicked current month = CALCULATE([Clicked #]/ [Total Users],FILTER(DateDim,DateDim[Report Month] = "Current Month")))

This works for Current Month but if I select a filter for June or Jan it does not calculate anything.

Thanks

[Greg_Deckler · Accepted solution]

@Anonymous  - Perhaps try this:

Percentage Clicked current month =

IF(HASONEVALUE(DateDim[Report Month), [Clicked #] / [Total Users], CALCULATE([Clicked #]/ [Total Users],FILTER(DateDim,DateDim[Report Month] = "Current Month")))

Woudl be easier with sample data, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.